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 |