## Passengers

ID | FirstName | LastName | DateOfBirth | IdentityType | IdentityNumber | IdentityVerification | Customer
--- | --- | --- | --- | --- | --- | --- | ---
1 | John | Doe | 1980-01-01 | Document | A123456789 | Biometric Authentication | Not James Davies
2 | Jane | Smith | 1990-02-02 | Card | MN098765432 | Manual Verification | Also Not James Davies
3 | Jimmy | Johnson | 1970-03-03 | Document | P098765432 | Manual Verification | Still Not James Davies
4 | Elizabeth | Williams | 1960-04-04 | Card | K987654321 | Biometric Authentication | Not James Davies Either
5 | David | White | 1950-05-05 | Card | L987654320 | Biometric Authentication | James Davies
6 | Emily | Green | 1940-06-06 | Document | I987654319 | Manual Verification | James Davies

## Flights

FlightID | DepartureAirport | ArrivalAirport | ScheduledDeparture | ActualDeparture | ScheduledArrival | ActualArrival | TotalDuration | AircraftModel | GateNumber
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | LAX | JFK | 08:00:00 | 08:15:00 | 10:00:00 | 10:15:00 | 2:30:00 | Boing 737 | 10
2 | ORD | ATL | 09:00:00 | 09:15:00 | 11:00:00 | 11:15:00 | 2:30:00 | Airbus A320 | 11
3 | DFW | MIA | 10:00:00 | 10:15:00 | 12:00:00 | 12:15:00 | 2:30:00 | Bombardier CRJ200 | 12
4 | IAH | MSY | 11:00:00 | 11:15:00 | 13:00:00 | 13:15:00 | 2:30:00 | Embraer E175 | 13
5 | EWR | PHL | 12:00:00 | 12:15:00 | 14:00:00 | 14:15:00 | 2:30:00 | United Airlines B737 | 14

## Bookings

BookingID | PassengerId | FlightID
--- | --- | ---
| (→ Passengers.ID) | (→ Flights.FlightID)
1 | 5 | 1
2 | 1 | 2
3 | 5 | 3
4 | 1 | 4
5 | 1 | 5

## Airports

AirportCode | City | Country | Latitude | Longitude
--- | --- | --- | --- | ---
LAX | Los Angeles | USA | 34.052235 | -118.243683
JFK | New York | USA | 40.641385 | -73.774927
ORD | Chicago | USA | 41.954541 | -87.662319
ATL | Atlanta | USA | 33.642674 | -84.393435
DFW | Dallas/Fort Worth | USA | 32.897666 | -97.025972
MIA | Miami | USA | 25.761703 | -80.191793

## Aircrafts

RegistrationCharters | Model | Manufacturer | YearOfManufacture | Capacity
--- | --- | --- | --- | ---
N100AW | Boeing 737-800 | Boeing Commercial Airplanes | 2010 | 210
N300DL | Airbus A320 | Airbus | 2015 | 180
N700WN | Bombardier CRJ200 | Bombardier Aerospace | 2008 | 50
N319UA | Embraer E175 | Embraer | 2012 | 80
N904UZ | United Airlines B737 | Boeing Commercial Airplanes | 2011 | 210

## AssignedTo

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