![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 24.05.2021 23:10 lakinbacon4
FLIGHT = ( FlightN, FromCity, ToCity, Date, DepartureTime, ArrivalTime ) //. You may use <, >, !=, or = between any two dates or between any two times. Also, you may assume the attribute Date = arrival date= departure date and that ToCity and FromCity are in the same time zone.
TICKET = ( TicketN, FlightN, Cost, Completed ) // Since Ticket# and Flight# together are the key, this means a single ticket may include several flights. Completed may assume the values ‘Yes’ or NULL, Null means the flight hasn’t been completed.
PASSENGER = ( Name , TicketN ) // This table includes every passenger and the ticket numbers he or she purchased. Assume the name of the passenger is unique.
Express the following queries by SQl statements using a minimum number of tables and operations:
1. List every possible flight schedule from "LA’ to "NY" with only one stop. The flight schedule includes DepartureTime time from LA, Name of a stop city, ArrivalTime to the stop, DepartureTime from the stop, ArrivalTime to NY. Assume both flights are on the same date.
2. Retrieve the names of every passenger and total amount paid for the tickets he/she purchased.
3. Retrieve the names of all passengers who have traveled to "LA’ at most two times. .
![ansver](/tpl/images/cats/User.png)
Answers: 2
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 16:00
An english teacher would like to divide 8 boys and 10 girls into groups, each with the same combination of boys and girls and nobody left out. what is the greatest number of groups that can be formed?
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 19:30
Of the following pieces of information in a document, for which would you most likely insert a mail merge field?
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 17:30
Click on the tab on the ribbon to open the backstage view. file view insert review
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 17:30
Which computer network component connects two different networks together and allows them to communicate? a is a node (or a device) that connects two different networks together and allows them to communicate.
Answers: 2
You know the right answer?
FLIGHT = ( FlightN, FromCity, ToCity, Date, DepartureTime, ArrivalTime ) //. You may use <, >,...
Questions
![question](/tpl/images/cats/istoriya.png)
History, 27.01.2020 19:31
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 27.01.2020 19:31
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/istoriya.png)
History, 27.01.2020 19:31
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 27.01.2020 19:31
![question](/tpl/images/cats/biologiya.png)
Biology, 27.01.2020 19:31
![question](/tpl/images/cats/en.png)
English, 27.01.2020 19:31
![question](/tpl/images/cats/mat.png)
Mathematics, 27.01.2020 19:31
![question](/tpl/images/cats/istoriya.png)
History, 27.01.2020 19:31
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/himiya.png)
Chemistry, 27.01.2020 19:31
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/fizika.png)
Physics, 27.01.2020 19:31
![question](/tpl/images/cats/himiya.png)
Chemistry, 27.01.2020 19:31