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 |