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: 1. Retrieve all rows in Airport table for all the airports in London city. 2. Retrieve all British and German passengers. 3. Retrieve all names of all the passengers. 4. Retrieve the flight number, departure and arrival airports of all British Airways. 5. Retrieve the name of every passenger together with their flight number and the associated company. 6. Retrieve all flights departed from all airports in London. 7. Retrieve the ticket numbers and names of all passenger departing from London. 8. Retrieve the flight number and flight company of all flights from London to Paris.
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:
1. Retrieve all rows in Airport table for all the airports in London city.
2. Retrieve all British and German passengers.
3. Retrieve all names of all the passengers.
4. Retrieve the flight number, departure and arrival airports of all British Airways.
5. Retrieve the name of every passenger together with their flight number and the
associated company.
6. Retrieve all flights departed from all airports in London.
7. Retrieve the ticket numbers and names of all passenger departing from London.
8. Retrieve the flight number and flight company of all flights from London to Paris.
Step by step
Solved in 2 steps with 3 images