Add a view that shows for each reservation on '6/8/2004' the passenger's name, the starting location, and the destination.
What will be an ideal response?
CREATE VIEW Trips (PassName, Start, Destination) AS
SELECT P.Name, F.Start, F.Destination
FROM Passenger P, Flights F, Reservations R
WHERE P.Id = R.PassengerId AND R.FlightId
Computer Science & Information Technology
You might also like to view...
Queries that have more than one criterion are sometimes called ________ queries
A) complex B) compound C) multiple D) composite
Computer Science & Information Technology
System protection is off by default
Indicate whether the statement is true or false
Computer Science & Information Technology
When you want more information about a specific color in your document, use the ____ to show the color values beneath the mouse pointer.
a. Info panel b. Color panel c. Mouse panel d. Value panel
Computer Science & Information Technology
The shape of a video can be edited in PowerPoint 2010
Indicate whether the statement is true or false
Computer Science & Information Technology