| FlightID | DepartureTime | ArrivalTime | Origin | Destination | TerminalNumber |
|---|---|---|---|---|---|
| 1 | 18:30 | 19:45 | LAX | JFK | 101 |
| 2 | 17:00 | 18:15 | ATL | ORD | 102 |
| 3 | 16:30 | 17:45 | DEN | MIA | 103 |
| 4 | 15:00 | 16:15 | SEA | MSP | 104 |
| 5 | 14:30 | 15:45 | PHX | IAH | 105 |
| PassengerID | FirstName | LastName | DateOfBirth | AvailableLocations |
|---|---|---|---|---|
| 1 | John | Smith | 1990-01-01 | Terminal A |
| 2 | Anna | Martin | 1985-05-01 | Terminal C |
| 3 | Michael | Williams | 1992-12-24 | Terminal A |
| 4 | Emma | Jones | 1988-08-01 | Terminal C |
| 5 | David | Brown | 1991-03-16 | Terminal A |
| LuggageServiceID | Description | Cost | LuggageAssistance | AvailableLocations |
|---|---|---|---|---|
| 1 | Luggage Trolley | 10.0 | No assistance provided. | Entrance B |
| 2 | Luggage Trolley | 15.0 | No assistance provided. | Departures D |
| 3 | Porter Service | 20.0 | Meet & Greet at Entrance. | Entrance B |
| 4 | Porter Service | 25.0 | Meet & Greet at Exit. | Exit E |
| 5 | Valet Parking | 30.0 | Car picked up inside terminal. | Arrivals F |
| ReservationID | FlightID | PassengerID | LuggageServiceID |
|---|---|---|---|
| (→ Flights.FlightID) | (→ Passengers.PassengerID) | (→ LuggageServices.LuggageServiceID) | |
| 1 | 1 | 1 | 1 |
| 2 | 2 | 2 | 3 |
| 3 | 3 | 3 | 5 |
| 4 | 4 | 4 | 3 |
| 5 | 5 | 5 | 1 |