| 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 |
| 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 |
| 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 |
| 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 |
| AssistantID | Name |
|---|---|
| 1 | Claire Allen |
| 2 | Emma Thompson |
| 3 | Jack Williams |
| 4 | Lucy Jones |
| 5 | Michael Johnson |
| 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 |