Food_Court

idnamelocationcuisine_typerevenue
1Grand CaféTerminal AContinental$1 Million
2Asian DelightsTerminal BAsianN/A

Retail_Shop

idnamelocationtyperevenue
1Duty Free ShopTerminal CElectronics & Accessories$1 Million
2Books GaloreTerminal DBook StoreN/A

Flight

idflight_numberdeparture_timearrival_timegate_number
112022-06-01 09:00:002022-06-01 11:00:0010
222022-06-02 07:00:002022-06-02 09:00:0020

Passenger

idfirst_namelast_namedate_of_birthpassport_number
1JohnSmith1990-06-01ABCD1234
2JaneDoe1991-07-02EFGH5678

Aircraft

idaircraft_modelcapacitymanufactureryear_built
1Boeing 737 Max200Boeing2000
2Airbus A320 Neo200Airbus2011

Baggage_Handling

idairport_codebaggage_weightdestination_airport_codehandling_fee
1LAX500.0ORD150
2ORD600.0LAX180