Airlines
| id | airline_name | alliance | independent_carrier |
| | (→ Alliances.id) | (→ Carriers.id) |
| 1 | American Airlines | 1 | 0 |
| 2 | United Airlines | 0 | 1 |
| 3 | Delta Airlines | 1 | 0 |
| 4 | Southwest Airlines | 1 | 1 |
| 5 | JetBlue Airways | 0 | 1 |
Aircrafts
| id | model | seats |
| 1 | Airbus A320 | 180 |
| 2 | Boeing 777 | 360 |
| 3 | Embraer E190 | 100 |
Flights
| id | airport_departure | airport_arrival | airline_id | aircraft_model | departure_time | arrival_time |
| (→ Airports.id) | (→ Airports.id) | (→ Airlines.id) | (→ Aircrafts.id) | | |
| 1 | None | None | 1 | 1 | 2023-01-01 09:00:00 | 2023-01-01 12:00:00 |
| 2 | None | None | 2 | 2 | 2023-01-01 10:00:00 | 2023-01-01 14:00:00 |
| 3 | None | None | 3 | 3 | 2023-01-01 11:00:00 | 2023-01-01 15:00:00 |
| 4 | None | None | 4 | 1 | 2023-01-01 12:00:00 | 2023-01-01 16:00:00 |
| 5 | None | None | 5 | 2 | 2023-01-01 13:00:00 | 2023-01-01 17:00:00 |
Alliances
| id | alliance_name |
| 1 | Star Alliance |
| 2 | OneWorld |
| 3 | SkyTeam |
Carriers
| id | carrier_name |
| 1 | Boeing |
| 2 | Embraer |
| 3 | Airbus |