Gate_Agents

IDNameLanguageYearsOfExperienceLicenseNumber
1JuanSpanish8A0923
2EmilyEnglish7B1263
3MichaelFrench6C3456
4OliviaGerman5D5678
5LiamItalian4E7890

Pilots

IDNameLanguageFlightHoursLicenseNumber
1AlbertoSpanish2000F0011
2DavidEnglish1800G0022
3IsabelleFrench1600H0033
4LeoGerman1400I0044
5MilanItalian1200J0055

Airlines

IDNameCodeHeadquarters
1American AirlinesAAFort Worth, Texas
2United AirlinesUAChicago, Illinois
3Delta AirlinesDLAtlanta, Georgia
4Southwest AirlinesWNDallas, Texas
5Spirit AirlinesNKMiramar, Florida

Flights

IDAirlineIDDepartureTimeArrivalTimeDestinationAirport
(→ Airlines.ID)
112023-04-01 10:00:002023-04-01 12:00:00New York JFK
222023-04-01 11:00:002023-04-01 13:00:00Los Angeles LAX
332023-04-01 12:00:002023-04-01 14:00:00Atlanta Hartsfield-Jackson
442023-04-01 13:00:002023-04-01 15:00:00Dallas Love Field
552023-04-01 14:00:002023-04-01 16:00:00Fort Lauderdale Hollywood

Passengers

IDFirstNameLastNameAgeNationality
1JohnSmith30USA
2JaneDoe25UK
3TomBrown40Canada
4AnnaWhite35Australia
5PaulGreen45France

Baggage

IDFlightIDOwnerIDWeightDescription
(→ Flights.ID)(→ Passengers.ID)
11110Laptop bag
21215Skis case
32320Golf clubs
42425Musical instruments
53530Stroller