TerminalFacility

idArrival_FacilitiesMaximum_CapacityOpeningHours
1Arrival Hall500 passengers06:00 - 23:00
2Arrival Hall1000 passengers07:00 - 22:00
3Baggage Reclaim500 passengers08:00 - 21:00
4Baggage Reclaim800 passengers09:00 - 20:00

Airports

idNameLocationNumberOfTerminals
(→ TerminalFacility.id)
1Los Angeles International AirportCalifornia, USA9
2Dubai International AirportUnited Arab Emirates3

Airlines

idNameHeadquartersIATA_Code
1EmiratesDubai, United Arab EmiratesEK
2American AirlinesFort Worth, Texas, U.S.AA

Flights

idFlightNoDepartureAirportIdDestinationAirportIdAirlineIdDepartsArrives
(→ Airports.id)(→ Airports.id)(→ Airlines.id)
111212023-04-01 10:00:002023-04-01 14:00:00
221322023-04-01 11:00:002023-04-01 15:00:00

Passengers

idFirstNameLastNameDateOfBirthFlightId
(→ Flights.id)
1JohnSmith1990-01-011
2JaneDoe1992-02-022