| AirlineID | Name | Headquarters |
|---|---|---|
| 1 | United Airlines | Chicago |
| 2 | Delta Airlines | Atlanta |
| 3 | American Airlines | Fort Worth |
| 4 | Southwest Airlines | Dallas |
| 5 | Alaska Airlines | Seattle |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |