Airports
| id | name | city | country |
| 1 | Airport A | City A | Country X |
| 2 | Airport B | City B | Country Y |
| 3 | Airport C | City C | Country Z |
| 4 | Airport D | City D | Country W |
| 5 | Airport E | City E | Country V |
Runways
| id | airport_id | length | width |
| (→ Airports.id) | | |
| 1 | 1 | 3000.0 | 45.0 |
| 2 | 2 | 2800.0 | 40.0 |
| 3 | 3 | 3200.0 | 45.0 |
| 4 | 4 | 2900.0 | 42.0 |
| 5 | 5 | 3100.0 | 45.0 |
Terminals
| id | airport_id | capacity |
| (→ Airports.id) | |
| 1 | 1 | 15 |
| 2 | 2 | 20 |
| 3 | 3 | 25 |
| 4 | 4 | 30 |
| 5 | 5 | 35 |
Airlines
| id | name | headquarters_city |
| 1 | Company A | City A |
| 2 | Company B | City B |
| 3 | Company C | City C |
| 4 | Company D | City D |
| 5 | Company E | City E |
Flights
| flight_number | airline_id | departure_time | arrival_time | origin_airport_id | destination_airport_id | aircraft_type |
| (→ Airlines.id) | | | (→ Airports.id) | (→ Airports.id) | |
| 1 | 1 | 2023-01-01 08:00:00 | 2023-01-01 10:00:00 | 1 | 2 | Boeing 737 |
| 2 | 2 | 2023-01-01 09:00:00 | 2023-01-01 11:00:00 | 2 | 3 | Airbus A320 |
| 3 | 3 | 2023-01-01 10:00:00 | 2023-01-01 12:00:00 | 3 | 1 | Boeing 747 |
| 4 | 4 | 2023-01-01 11:00:00 | 2023-01-01 13:00:00 | 4 | 5 | Embraer ERJ 190 |
| 5 | 5 | 2023-01-01 12:00:00 | 2023-01-01 14:00:00 | 5 | 2 | Airbus A380 |
Airport_Staff
| staff_id | role | salary | hire_date |
| (→ Airports.id) | | | |
| 1 | Air Traffic Controller | $60,000 per year | 2022-01-01 |
| 2 | Air Traffic Controller | other amount | 2022-02-01 |
| 3 | Ground Staff | $60,000 per year | 2022-01-01 |
| 4 | Ground Staff | other amount | 2022-02-01 |
| 5 | other role | arbitrary amount | arbitrary date |