Retrieve all rows in Airport table for all the airports in London city. Retrieve all British and German passengers. Retrieve all names of all the passengers.
Course:
Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data.
The data is described in the following relation schemas:
Airport (airportID, name, city)
Passenger (ticketNo, name, nationality, flightNo, seatNo)
FK: flightNo references Flight (flightNo)
FK: seatNo references Seat (seatNo)
Flight (flightNo, flightCompany, departAirport, arrivalAirport)
FK: departAirport references Airport (airportID)
FK: arrivalAirport references Airport (airportID)
Seat (seatNo, flightNo, class)
FK: flightNo references Flight (flightNo)
#Construct the SQL statements based on following transactions:
please if you could give all the sql statements needed i will appreciate that, and i promise to put thump up
| Transaction | SQL Statement |
| Retrieve all rows in Airport table for all the airports in London city. | |
| Retrieve all British and German passengers. | |
| Retrieve all names of all the passengers. | |
| Retrieve the flight number, departure and arrival airports of all British Airways. | |
| Retrieve the name of every passenger together with their flight number and the associated company. | |
| Retrieve all flights departed from all airports in London. | |
| Retrieve the ticket numbers and names of all passenger departing from London. | |
| Retrieve the flight number and flight company of all flights from London to Paris. |
Step by step
Solved in 3 steps
