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 |
---|---|---|---|
1 | Alice | Smith | 1990-01-15 |
2 | Bob | Johnson | 1985-02-20 |
3 | Carol | Williams | 1992-03-25 |
4 | David | Brown | 1988-04-05 |
5 | Eva | Miller | 1994-05-10 |
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 |