Aircraft

idName
1Boeing 787 Dreamliner
2Airbus A380

Onboard_Services

idService_nameAircraft_id
(→ Aircraft.id)
1Free WiFi1
2Meals2
3In-flight magazines2

Inflight_Entertainments

idEntertainment_nameAircraft_id
(→ Aircraft.id)
1Movies1
2Music2
3Games2

Passengers

idFirst_nameLast_nameAgeFlight_number
(→ Flights.id)
1JohnDoe35101
2JaneSmith28102
3AliceJohnson42103
4BobWilliams60104
5EmmaMartin22105

Flights

idDeparture_timeArrival_timeOrigin_airportDestination_airportAircraft_id
(→ Aircraft.id)
1012022-11-01 10:002022-11-01 14:00LAXORD1
1022022-11-02 09:302022-11-02 13:30DFWYUL1
1032022-11-03 10:002022-11-03 14:00LAXJFK2
1042022-11-04 09:302022-11-04 13:30DFWYYZ2
1052022-11-05 10:002022-11-05 14:00LAXLHR2

Baggage

idWeight_kgTypeFlight_number
(→ Flights.id)
125Checked Luggage101
210Carry-on Luggage102
315Checked Luggage103
45Carry-on Luggage104
520Checked Luggage105