City

idnamecountry
1New YorkUSA
2LondonUK
3TokyoJapan
4ParisFrance
5DubaiUAE

Flight

idflight_numberdeparture_timearrival_timeterminal_idorigin_city_iddestination_city_id
(→ Terminal.id)(→ City.id)(→ City.id)
1AA1012022-12-01 08:00:002022-12-01 10:00:00113
2BA2012022-12-01 11:00:002022-12-01 13:00:00224
3JL3012022-12-01 15:00:002022-12-01 17:00:00335
4AF4012022-12-01 19:00:002022-12-01 21:00:00441
5EK6012022-12-01 22:00:002022-12-02 02:00:00552

Airline

idairline_nameheadquarter_city_id
(→ City.id)
1American Airlines1
2British Airways2
3All Nippon Airways3
4Air France4
5Emirates5

Pilot

idpilot_license_numberhome_airport_code
(→ City.name)
1ABC1234NY
2DEF5678LDN
3GHI9012TYO
4JKL3456CDG
5MNO7890DBX

Plane

idplane_typecapacityregistered_to_airline_idcurrent_pilot_id
(→ Airline.id)(→ Pilot.id)
1Boeing 77735011
2Boeing 74740022
3Airbus A38050033
4Airbus A32020044
5Bombardier CRJ10009055

Terminal

idterminal_name
1Terminal 1
2Terminal 2
3Terminal 3
4Terminal 4
5Terminal 5