Airlines

AirlineIDNameHeadquarters
1United AirlinesChicago
2Delta AirlinesAtlanta
3American AirlinesFort Worth
4Southwest AirlinesDallas
5Alaska AirlinesSeattle

Flights

FlightIDDepartureTimeArrivalTimeOriginAirportIDDestinationAirportID
(→ Airports.AirportID)(→ Airports.AirportID)
12023-01-01 06:002023-01-01 08:0012
22023-01-02 07:002023-01-02 09:0034
32023-01-03 08:002023-01-03 10:0025
42023-01-04 09:002023-01-04 11:0041
52023-01-05 10:002023-01-05 12:0053

Airports

AirportIDNameCityCountryPickUpDropOffLocations
1John F. Kennedy International AirportNew YorkUSAEntrance A
2Hartsfield-Jackson Atlanta International AirportAtlantaUSAGate B
3Los Angeles International AirportLos AngelesUSACurbside C
4Dallas/Fort Worth International AirportDallasUSATerminal E
5Sea-Tac International AirportSeattleUSAMain Terminal

WheelChairAssistanceRequests

RequestIDPassengerNameFlightIDDateRequestedAssistanceRequired
(→ Flights.FlightID)
1Anna Smith12023-01-011
2Michael Brown22023-01-020
3David Johnson32023-01-031
4Amy Williams42023-01-040
5Nathan Taylor52023-01-051

MobilityScooterRequests

RequestIDPassengerNameFlightIDDateRequestedScooterRequired
(→ Flights.FlightID)
1Lisa Thompson12023-01-010
2Richard Lee22023-01-021
3Karen Clark32023-01-030
4Mark Green42023-01-041
5Laura Wilson52023-01-050

Employees

EmployeeIDFirstNameLastNamePositionDepartment
1JaneSmithCustomer Service ManagerPassenger Services
2JohnBrownSecurity OfficerSecurity
3AliceDavisAir Traffic ControllerOperations
4TomMartinPilotFlight Operations
5RachelGarciaCabin CrewPassenger Services