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. .
Answers: 2
Computers and Technology, 21.06.2019 23:00
In a file-oriented information system, a work file stores relatively permanent data about an entity is created and saved for backup and recovery purposes stores records that contain day-to-day business and operational data is a temporary file created by an information system for a single task
Answers: 1
Computers and Technology, 23.06.2019 22:20
Read âsuburban homes construction projectâ at the end of chapters 8 and 9 (in the textbook) and then develop a wbs (work breakdown structure) in microsoft excel or in microsoft word (using tables)
Answers: 1
Computers and Technology, 25.06.2019 16:30
Acompany wants to inform a select list of it's regular customers about a flash sale. which type of platform will it use to send the information and how ? the company can use (email , letter,instant messaging ,) to inform it's customers . the email recipient addresses can be selected using (mail merge , compose , forward
Answers: 1
FLIGHT = ( FlightN, FromCity, ToCity, Date, DepartureTime, ArrivalTime ) //. You may use <, >,...
Mathematics, 03.06.2021 15:40
Mathematics, 03.06.2021 15:40
Mathematics, 03.06.2021 15:40
History, 03.06.2021 15:40
Chemistry, 03.06.2021 15:40
Chemistry, 03.06.2021 15:40
Mathematics, 03.06.2021 15:40