Flight

FlightIDOriginDestinationDepartureTime
1JFKLAX2023-04-01 08:00:00
2ORDATL2023-04-02 10:00:00
3SEADEN2023-04-03 12:00:00
4IAHMIA2023-04-04 14:00:00
5DFWPHX2023-04-05 16:00:00

Passenger

PassengerIDFirstNameLastNameEmailPhoneNumber
1JohnSmithjohnsmith@email.com555-123-4567
2JaneDoejanedoe@email.com555-987-6543
3AliceJohnsonalicejohnson@email.com555-432-1234
4BobWilliamsbobwilliams@email.com555-654-3219
5EmmaBrownemmabrown@email.com555-111-2222

Assistant

AssistantIDNameContactInfo
1Clare Allenclareallen@assistant.com; +1-234-567-8900
2David Johnsondavidjohnson@assistant.com; +1-345-678-9012

UnaccompaniedMinor

UMIDPassengerIDAssistantID
(→ Passenger.PassengerID)(→ Assistant.AssistantID)
111
222

SpecialNeedsPassenger

SNPIDPassengerIDAssistantID
(→ Passenger.PassengerID)(→ Assistant.AssistantID)
131
242

Booking

BookingIDFlightIDPassengerIDUMIDSNPID
(→ Flight.FlightID)(→ Passenger.PassengerID)(→ UnaccompaniedMinor.UMID)(→ SpecialNeedsPassenger.SNPID)
1111None
222None1
33322
4441None
555None1