## Flights

FlightID | DepartureTime | ArrivalTime | Origin | Destination
--- | --- | --- | --- | ---
1 | 10:00:00 | 13:00:00 | JFK | LAX
2 | 14:00:00 | 17:00:00 | ORD | ATL
3 | 06:00:00 | 09:00:00 | YYZ | YUL
4 | 18:00:00 | 21:00:00 | CDG | DUB
5 | 09:00:00 | 12:00:00 | PEK | HKG

## Airports

AirportID | Name | City | Country
--- | --- | --- | ---
1 | John F. Kennedy International Airport | New York | USA
2 | Chicago O'Hare International Airport | Chicago | USA
3 | Toronto Pearson International Airport | Toronto | Canada
4 | Charles de Gaulle Airport | Paris | France
5 | Hong Kong International Airport | Hong Kong | Hong Kong

## Airlines

AirlineID | Name | HeadquartersCity | HomeAirportId
--- | --- | --- | ---
|  |  | (→ Airports.AirportID)
1 | American Airlines | Fort Worth | 1
2 | United Airlines | Chicago | 2
3 | Air Canada | Montreal | None
4 | Air France | Tremblay-en-France | 4
5 | Cathay Pacific | Hong Kong | 5

## Passengers

PassengerID | FirstName | LastName | DateOfBirth | SpecialNeeds
--- | --- | --- | --- | ---
1 | Alice | Smith | 1990-01-15 | 1
2 | Bob | Johnson | 1985-02-20 | 0
3 | Carol | Williams | 1992-03-25 | 0
4 | David | Brown | 1988-04-05 | 1
5 | Eva | Miller | 1994-05-10 | 0

## Assistants

AssistantID | Name
--- | ---
1 | Claire Allen
2 | Emma Thompson
3 | Jack Williams
4 | Lucy Jones
5 | Michael Johnson

## PassengerAssistanceRequests

RequestID | PassengerID | AssistantID | Type
--- | --- | --- | ---
| (→ Passengers.PassengerID) | (→ Assistants.AssistantID) |
1 | 1 | 1 | Unaccompanied Minor
2 | 2 | 2 | Unaccompanied Minor
3 | 3 | 1 | Special Needs
4 | 4 | 3 | Special Needs
5 | 5 | 4 | General Assistance