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 |