Flights

FlightIDDepartureTimeDestinationOriginFlightNumberTypeAirlineID
(→ Airlines.AirlinesID)
12023-01-01 08:00New YorkLos AngelesAA123Boeing 7371
22023-01-01 10:00ChicagoMiamiUA678Boeing 7472
32023-01-01 12:00DallasAtlantaDL987Airbus A3203
42023-01-01 14:00PhiladelphiaPhoenixSW456Bombardier Q4004
52023-01-01 16:00San FranciscoHonoluluJB234Boeing 7875

Airlines

AirlinesIDName
1American Airlines
2United Airlines
3Delta Airlines
4Southwest Airlines
5JetBlue Airlines

Facilities

FacilityIDDescription
1Free WiFi access for passengers.
2Business center with printing services.
3Kids play area for families.
4VIP lounge for premium customers.
5Currency exchange services.

Departures_Facilities

DepartureIDFacilityID
(→ Flights.FlightID)(→ Facilities.FacilityID)
11
22
33
44
55

Arrivals_Facilities

ArrivalIDFacilityID
(→ Flights.FlightID)(→ Facilities.FacilityID)
11
22
33
44
55