Airports
| id | name | city | country |
| 1 | A1 | City A | Country A |
| 2 | A2 | City B | Country B |
| 3 | A3 | City C | Country C |
| 4 | A4 | City D | Country D |
| 5 | A5 | City E | Country E |
Airlines
| id | airlineName | headquarteredIn | homeAirportId |
| | | (→ Airports.id) |
| 1 | Alaska Airlines | USA | None |
| 2 | Delta Airlines | USA | None |
| 3 | United Airlines | USA | None |
| 4 | American Airlines | USA | None |
| 5 | JetBlue Airways | USA | None |
Flights
| id | flightNo | departureTime | arrivalTime | originAirportId | destinationAirportId | aircraftId |
| | | | (→ Airports.id) | (→ Airports.id) | (→ Manufactures.id) |
| 1 | AA1 | 2022-01-01 10:00:00 | 2022-01-01 15:00:00 | 1 | 2 | 1 |
| 2 | DL1 | 2022-01-01 11:00:00 | 2022-01-01 16:00:00 | 2 | 3 | 2 |
| 3 | UA1 | 2022-01-01 12:00:00 | 2022-01-01 17:00:00 | 3 | 4 | 3 |
| 4 | AS1 | 2022-01-01 13:00:00 | 2022-01-01 18:00:00 | 4 | 5 | 4 |
| 5 | B61 | 2022-01-01 14:00:00 | 2022-01-01 19:00:00 | 5 | 1 | 5 |
Manufactures
| id | aircraftModel | manufacturers | numberOfSeats |
| 1 | 737 MAX | Boeing | 180 |
| 2 | A320neo | Airbus | 180 |
| 3 | Bombardier CRJ900 | Canada | 65 |
| 4 | Embraer ERJ-170 | Brazil | 68 |
| 5 | Airbus A220 | Airbus | 130 |