Airlines
| id | name | headquarters |
| 1 | American Airlines | Fort Worth |
| 2 | Delta Airlines | Atlanta |
| 3 | United Airlines | Chicago |
| 4 | Southwest Airlines | Dallas |
| 5 | Alaska Airlines | Seattle |
AircraftTypes
| id | typeName | manufacturer |
| 1 | 737 | Boeing |
| 2 | A320 | Airbus |
| 3 | 787 | Boeing |
| 4 | A350 | Airbus |
| 5 | A380 | Airbus |
Planes
| id | model | number_of_seats | aircraftTypeId | airlineId |
| | | (→ AircraftTypes.id) | (→ Airlines.id) |
| 1 | 737-800 | 169 | 1 | 1 |
| 2 | A320-200 | 180 | 2 | 2 |
| 3 | 787-9 | 284 | 3 | 3 |
| 4 | A350-1000 | 440 | 4 | 4 |
| 5 | A380-800 | 514 | 5 | 5 |
| 6 | Boeing 747-8i | 467 | 6 | 6 |
BoeingPlanes
| planeId | boeing |
| (→ Planes.id) | |
| 1 | 0 |
| 2 | 0 |
| 3 | 0 |
| 4 | 0 |
| 5 | 0 |
AirbusPlanes
| planeId | airbus |
| (→ Planes.id) | |
| 2 | 0 |
| 3 | 0 |
| 4 | 0 |
| 5 | 0 |
| 6 | 0 |
FlightRoutes
| routeId | originAirportCode | destinationAirportCode | flightNumber | planeId |
| | | | (→ Planes.id) |
| 1 | JFK | LAX | 123 | 1 |
| 2 | ORD | ATL | 456 | 2 |
| 3 | IAD | MCO | 789 | 3 |
| 4 | SEA | PHX | 101 | 4 |
| 5 | SFO | YVR | 202 | 5 |
| 6 | EWR | MIA | 303 | 6 |