Course: Database *(SQL)*
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 theSQL statements based on following transactions:
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. |
|