Airlines

idnameheadquarters
1American AirlinesFort Worth
2Delta AirlinesAtlanta
3United AirlinesChicago
4Southwest AirlinesDallas
5Alaska AirlinesSeattle

AircraftTypes

idtypeNamemanufacturer
1737Boeing
2A320Airbus
3787Boeing
4A350Airbus
5A380Airbus

Planes

idmodelnumber_of_seatsaircraftTypeIdairlineId
(→ AircraftTypes.id)(→ Airlines.id)
1737-80016911
2A320-20018022
3787-928433
4A350-100044044
5A380-80051455
6Boeing 747-8i46766

BoeingPlanes

planeIdboeing
(→ Planes.id)
10
20
30
40
50

AirbusPlanes

planeIdairbus
(→ Planes.id)
20
30
40
50
60

FlightRoutes

routeIdoriginAirportCodedestinationAirportCodeflightNumberplaneId
(→ Planes.id)
1JFKLAX1231
2ORDATL4562
3IADMCO7893
4SEAPHX1014
5SFOYVR2025
6EWRMIA3036