Passengers

IDFirstNameLastNameDateOfBirthIdentityTypeIdentityNumberIdentityVerificationCustomer
1JohnDoe1980-01-01DocumentA123456789Biometric AuthenticationNot James Davies
2JaneSmith1990-02-02CardMN098765432Manual VerificationAlso Not James Davies
3JimmyJohnson1970-03-03DocumentP098765432Manual VerificationStill Not James Davies
4ElizabethWilliams1960-04-04CardK987654321Biometric AuthenticationNot James Davies Either
5DavidWhite1950-05-05CardL987654320Biometric AuthenticationJames Davies
6EmilyGreen1940-06-06DocumentI987654319Manual VerificationJames Davies

Flights

FlightIDDepartureAirportArrivalAirportScheduledDepartureActualDepartureScheduledArrivalActualArrivalTotalDurationAircraftModelGateNumber
1LAXJFK08:00:0008:15:0010:00:0010:15:002:30:00Boing 73710
2ORDATL09:00:0009:15:0011:00:0011:15:002:30:00Airbus A32011
3DFWMIA10:00:0010:15:0012:00:0012:15:002:30:00Bombardier CRJ20012
4IAHMSY11:00:0011:15:0013:00:0013:15:002:30:00Embraer E17513
5EWRPHL12:00:0012:15:0014:00:0014:15:002:30:00United Airlines B73714

Bookings

BookingIDPassengerIdFlightID
(→ Passengers.ID)(→ Flights.FlightID)
151
212
353
414
515

Airports

AirportCodeCityCountryLatitudeLongitude
LAXLos AngelesUSA34.052235-118.243683
JFKNew YorkUSA40.641385-73.774927
ORDChicagoUSA41.954541-87.662319
ATLAtlantaUSA33.642674-84.393435
DFWDallas/Fort WorthUSA32.897666-97.025972
MIAMiamiUSA25.761703-80.191793

Aircrafts

RegistrationChartersModelManufacturerYearOfManufactureCapacity
N100AWBoeing 737-800Boeing Commercial Airplanes2010210
N300DLAirbus A320Airbus2015180
N700WNBombardier CRJ200Bombardier Aerospace200850
N319UAEmbraer E175Embraer201280
N904UZUnited Airlines B737Boeing Commercial Airplanes2011210

AssignedTo

FlightIDRegistrationCharters
(→ Flights.FlightID)(→ Aircrafts.RegistrationCharters)
1N100AW
2N300DL
3N700WN
4N319UA
5N904UZ