Question: Below is a database showing the daily train schedule for a train station. Departure TimeDestinationTrackLocal / Express 8 : 0 0 AMBrussels 1 Express 9

Below is a database showing the daily train schedule for a train station.
Departure TimeDestinationTrackLocal/Express8:00AMBrussels1Express9:15 AMHelsinki2Local9:22 AMMunich1Local9:32 AMHelsinki1Express11:00 AMAmsterdam1Express11:17 AMHelsinki2Local11:44 AMAmsterdam2Local
What series of operations should be performed in order to get the departure times of all the Express trains to Amsterdam?
Below is a database showing the daily train schedule for a train station.
Departure TimeDestinationTrackLocal/Express8:00AMBrussels1Express9:15 AMHelsinki2Local9:22 AMMunich1Local9:32 AMHelsinki1Express11:00 AMAmsterdam1Express11:17 AMHelsinki2Local11:44 AMAmsterdam2Local
What series of operations should be performed in order to get the departure times of all the Express trains to Amsterdam?
SELECT[Express/Local = "Express"]
PROJECT[Destination, Departure Time]
SELECT[Destination = "Amsterdam" and Express/Local = "Express"]
PROJECT[Departure Time]
SELECT[Destination = "Amsterdam" and Express/Local = "Express"]
PROJECT[Departure Time, Track]
SELECT[Destination = "Amsterdam"]
PROJECT[Express/Local, Departure Time]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!