Airplanes
| id | model | capacity |
| 1 | Boeing 787 Dreamliner | 300 |
| 2 | Airbus A321neo | 200 |
| 3 | Embraer E195 | 106 |
| 4 | Bombardier CRJ900 | 86 |
| 5 | A380 Superjumbo | 853 |
Cabin_Classes
| id | class_name |
| 1 | Economy Class |
| 2 | Business Class |
| 3 | First Class |
| 4 | Premium Economy |
| 5 | Full-Flat Bed |
Airports
| id | name | location |
| 1 | New York JFK | New York City, USA |
| 2 | Los Angeles LAX | Los Angeles, USA |
| 3 | Dubai DXB | Dubai, UAE |
| 4 | London Heathrow LHR | London, UK |
| 5 | Tokyo Haneda HND | Tokyo, Japan |
Flights
| id | flight_number | departure_airport_id | arrival_airport_id | airplane_id | departure_time |
| | (→ Airports.id) | (→ Airports.id) | (→ Airplanes.id) | |
| 1 | AA123 | 1 | 2 | 1 | 2022-01-01T08:00:00Z |
| 2 | DL456 | 2 | 5 | 2 | 2022-01-01T12:00:00Z |
| 3 | BA987 | 3 | 4 | 3 | 2022-01-01T16:00:00Z |
| 4 | QR123 | 4 | 1 | 4 | 2022-01-01T20:00:00Z |
| 5 | JL567 | 5 | 3 | 5 | 2022-01-01T24:00:00Z |
Airplanes_Cabin_Classes
| airplane_id | cabin_class_id |
| (→ Airplanes.id) | (→ Cabin_Classes.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |