## Flight

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

## Passenger

PassengerID | FirstName | LastName | Email | 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

## Assistant

AssistantID | Name | ContactInfo
--- | --- | ---
1 | Clare Allen | clareallen@assistant.com; +1-234-567-8900
2 | David Johnson | davidjohnson@assistant.com; +1-345-678-9012

## UnaccompaniedMinor

UMID | PassengerID | AssistantID
--- | --- | ---
| (→ Passenger.PassengerID) | (→ Assistant.AssistantID)
1 | 1 | 1
2 | 2 | 2

## SpecialNeedsPassenger

SNPID | PassengerID | AssistantID
--- | --- | ---
| (→ Passenger.PassengerID) | (→ Assistant.AssistantID)
1 | 3 | 1
2 | 4 | 2

## Booking

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