Airports

idnamecitycountry
1Los Angeles International AirportLos AngelesUSA
2Dubai International AirportDubaiUAE
3London Heathrow AirportLondonUK
4Tokyo Haneda AirportTokyoJapan
5Sydney Kingsford Smith AirportSydneyAustralia

Airlines

idnameallianceindependent_carrier
1American AirlinesOneWorld0
2EmiratesNone1
3British AirwaysOneWorld0
4ANANone0
5QantasOneWorld0

Aircrafts

idmodelmax_capacity
1Airbus A320180
2Boeing 747400
3Airbus A380850
4Boeing 777360
5Embraer E190100

Alliance_Aircraft

airline_allianceaircraft
(→ Airlines.name)(→ Aircrafts.model)
American AirlinesAirbus A320
British AirwaysBoeing 747

Independent_Aircraft

independent_carrieraircraft
(→ Airlines.name)(→ Aircrafts.model)
EmiratesAirbus A320
QantasBoeing 777

Flights

flight_iddeparture_airportarrival_airportairline_idaircraft_id
(→ Airports.id)(→ Airports.id)(→ Airlines.id)(→ Aircrafts.id)
11211
22122
33433
44344
55155