## Airlines

AirlineID | Name | Headquarters
--- | --- | ---
1 | United Airlines | Chicago
2 | Delta Airlines | Atlanta
3 | American Airlines | Fort Worth
4 | Southwest Airlines | Dallas
5 | Alaska Airlines | Seattle

## Flights

FlightID | DepartureTime | ArrivalTime | OriginAirportID | DestinationAirportID
--- | --- | --- | --- | ---
|  |  | (→ Airports.AirportID) | (→ Airports.AirportID)
1 | 2023-01-01 06:00 | 2023-01-01 08:00 | 1 | 2
2 | 2023-01-02 07:00 | 2023-01-02 09:00 | 3 | 4
3 | 2023-01-03 08:00 | 2023-01-03 10:00 | 2 | 5
4 | 2023-01-04 09:00 | 2023-01-04 11:00 | 4 | 1
5 | 2023-01-05 10:00 | 2023-01-05 12:00 | 5 | 3

## Airports

AirportID | Name | City | Country | PickUpDropOffLocations
--- | --- | --- | --- | ---
1 | John F. Kennedy International Airport | New York | USA | Entrance A
2 | Hartsfield-Jackson Atlanta International Airport | Atlanta | USA | Gate B
3 | Los Angeles International Airport | Los Angeles | USA | Curbside C
4 | Dallas/Fort Worth International Airport | Dallas | USA | Terminal E
5 | Sea-Tac International Airport | Seattle | USA | Main Terminal

## WheelChairAssistanceRequests

RequestID | PassengerName | FlightID | DateRequested | AssistanceRequired
--- | --- | --- | --- | ---
|  | (→ Flights.FlightID) |  |
1 | Anna Smith | 1 | 2023-01-01 | 1
2 | Michael Brown | 2 | 2023-01-02 | 0
3 | David Johnson | 3 | 2023-01-03 | 1
4 | Amy Williams | 4 | 2023-01-04 | 0
5 | Nathan Taylor | 5 | 2023-01-05 | 1

## MobilityScooterRequests

RequestID | PassengerName | FlightID | DateRequested | ScooterRequired
--- | --- | --- | --- | ---
|  | (→ Flights.FlightID) |  |
1 | Lisa Thompson | 1 | 2023-01-01 | 0
2 | Richard Lee | 2 | 2023-01-02 | 1
3 | Karen Clark | 3 | 2023-01-03 | 0
4 | Mark Green | 4 | 2023-01-04 | 1
5 | Laura Wilson | 5 | 2023-01-05 | 0

## Employees

EmployeeID | FirstName | LastName | Position | Department
--- | --- | --- | --- | ---
1 | Jane | Smith | Customer Service Manager | Passenger Services
2 | John | Brown | Security Officer | Security
3 | Alice | Davis | Air Traffic Controller | Operations
4 | Tom | Martin | Pilot | Flight Operations
5 | Rachel | Garcia | Cabin Crew | Passenger Services