| FlightID | Origin | Destination | DepartureTime |
|---|---|---|---|
| 1 | JFK | LAX | 2023-04-01 08:00:00 |
| 2 | ORD | ATL | 2023-04-02 10:00:00 |
| 3 | SEA | DEN | 2023-04-03 12:00:00 |
| 4 | IAH | MIA | 2023-04-04 14:00:00 |
| 5 | DFW | PHX | 2023-04-05 16:00:00 |
| PassengerID | FirstName | LastName | PhoneNumber | |
|---|---|---|---|---|
| 1 | John | Smith | johnsmith@email.com | 555-123-4567 |
| 2 | Jane | Doe | janedoe@email.com | 555-987-6543 |
| 3 | Alice | Johnson | alicejohnson@email.com | 555-432-1234 |
| 4 | Bob | Williams | bobwilliams@email.com | 555-654-3219 |
| 5 | Emma | Brown | emmabrown@email.com | 555-111-2222 |
| AssistantID | Name | ContactInfo |
|---|---|---|
| 1 | Clare Allen | clareallen@assistant.com; +1-234-567-8900 |
| 2 | David Johnson | davidjohnson@assistant.com; +1-345-678-9012 |
| UMID | PassengerID | AssistantID |
|---|---|---|
| (→ Passenger.PassengerID) | (→ Assistant.AssistantID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| SNPID | PassengerID | AssistantID |
|---|---|---|
| (→ Passenger.PassengerID) | (→ Assistant.AssistantID) | |
| 1 | 3 | 1 |
| 2 | 4 | 2 |
| BookingID | FlightID | PassengerID | UMID | SNPID |
|---|---|---|---|---|
| (→ Flight.FlightID) | (→ Passenger.PassengerID) | (→ UnaccompaniedMinor.UMID) | (→ SpecialNeedsPassenger.SNPID) | |
| 1 | 1 | 1 | 1 | None |
| 2 | 2 | 2 | None | 1 |
| 3 | 3 | 3 | 2 | 2 |
| 4 | 4 | 4 | 1 | None |
| 5 | 5 | 5 | None | 1 |