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 |
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 |
BookingID | PassengerId | FlightID |
---|---|---|
(→ Passengers.ID) | (→ Flights.FlightID) | |
1 | 5 | 1 |
2 | 1 | 2 |
3 | 5 | 3 |
4 | 1 | 4 |
5 | 1 | 5 |
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 |
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 |
FlightID | RegistrationCharters |
---|---|
(→ Flights.FlightID) | (→ Aircrafts.RegistrationCharters) |
1 | N100AW |
2 | N300DL |
3 | N700WN |
4 | N319UA |
5 | N904UZ |