Table Creation:

Write all SQL statements used to create your tables.

Database State:

Write all SQL statements used to insert values into the database

Table Screenshot:

List all your table instance/data, after the insertion process take screenshot from each table.

Query Implementation:

Views list:

Available Airplanes: This view returns the airplane type name, max seats, manufacture company and number of available airplanes from that type.

Airports: This view returns the name and code of the Airports for each Care Airplane type.

Flight legs : This view returns all flight legs, working weekdays and airlines based on their flight number.

Reservations: This view returns the name and phone number for each customer along with the seat no that are assigned to him/her, the number of the flight, date of flight, scheduled departure time, scheduled arrival time, departure airport and arrival airport.

Queries list:

List name and phone number for each customer whose flight date is 1-1-2023.

List flight fare for each flight with at least two legs.

List all airplanes id from Boeing company.

Find the most visited airport.

Find the highest flight fare and the number of its legs.

List all morning flights legs.

List all airplane types that can land in Riyadh.

List all the delayed legs.

List all flights legs from Saudia airlines on Monday.

List all legs that arrives 1-1-2023 in Jeddah.

Find the smallest airplane.

Find the shortest and cheapest flight.

Create and show the result of two views and eight queries form the above lists.

Conceptual Data Model Ikelational Databas Schema AirportCode. Iypekame