airports

idname
1Auckland
2Los Angeles
3Tokyo
4Dubai
5New York

flights

idfrom_airport_idto_airport_id
(→ airports.id)(→ airports.id)
112
234
356
478
5910

planes

idmodelmanufacturernumber_of_seats
1Boeing 787Boeing180
2Boeing 787Boeing200
3Airbus A380Airbus180
4Airbus A380Airbus200
5Bombardier CRJ900Embraer88
6Bombardier Q400De Havilland Canada78

manufacturers

idname
1Boeing
2Airbus
3Embraer
4De Havilland Canada

plane_details

plane_idmanufacturer_id
(→ planes.id)(→ manufacturers.id)
11
21
32
43
54