airports

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

flights

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

manufacturers

idname
1Boeing
2Airbus
3Embraer
4De Havilland Canada

plane_details

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

planes

idmodelnumber_of_seats
1Boeing 787180
2Boeing 787200
3Airbus A380180
4Airbus A380200
5Bombardier CRJ90088
6Bombardier Q40078