Flights
| flight_number | departure | arrival | aircraft_id |
| | | (→ Aircrafts.aircraft_id) |
| 1 | 2023-01-01 07:00 | 2023-01-01 10:00 | 1 |
| 2 | 2023-01-01 08:00 | 2023-01-01 11:00 | 2 |
| 3 | 2023-01-01 09:00 | 2023-01-01 12:00 | 3 |
| 4 | 2023-01-01 10:00 | 2023-01-01 13:00 | 4 |
| 5 | 2023-01-01 11:00 | 2023-01-01 14:00 | 5 |
Passengers
| passenger_id | firstname | lastname |
| 1 | John | Doe |
| 2 | Jane | Smith |
| 3 | Alice | Brown |
| 4 | Michael | Johnson |
| 5 | Emily | Williams |
Aircrafts
| aircraft_id | model | capacity |
| 1 | Boeing 747 | 400 |
| 2 | Airbus A380 | 800 |
| 3 | Bombardier CRJ200 | 50 |
| 4 | Embraer E195 | 100 |
| 5 | Airbus A320 | 160 |
Locations
| location_id | terminal_number | gate_number |
| 1 | 3 | 10 |
| 2 | 1 | 20 |
| 3 | 2 | 30 |
| 4 | 1 | 40 |
| 5 | 2 | 50 |
RetailOutlets
| outlet_id | name | location_id |
| | (→ Locations.location_id) |
| 1 | Duty-Free Shop | 1 |
| 2 | Duty-Free Shop | 5 |
| 3 | Souvenir Store | 1 |
| 4 | Souvenir Store | 5 |
| 5 | Bookstore | 2 |
| 6 | Coffee Shop | 3 |
| 7 | Fast Food Restaurant | 4 |