Airports

idCityCoordinatesIATA_CodeICAO_CodeAltitude
(→ Flights.IATA_Departure)(→ Flights.ICAO_Arrival)
1New York40.641798,-73.942208JFKKJFK12
2Los Angeles34.052235,-118.243683LAXKLAX30
3Chicago41.878113,-87.629799ORDKORD601
4Dallas32.782812,-96.802623DFWKDFW465
5Miami25.761703,-80.191797MIAKMIA10

Flights

Flight_IDDeparture_TimeArrival_TimeDurationSeatsIATA_DepartureICAO_ArrivalPriceForeignKey_Airline
(→ Airports.IATA_Code)(→ Airports.ICAO_Code)(→ Airlines.Airlines_Id)
12023-01-01 08:00:002023-01-01 12:00:00180250JFKKATL2501
22023-01-02 09:00:002023-01-02 13:00:00180250LAXKSFO2602
32023-01-03 10:00:002023-01-03 14:00:00180250ORDKPHX2403
42023-01-04 11:00:002023-01-04 15:00:00180250DFWKEWR2504
52023-01-05 12:00:002023-01-05 16:00:00180250MIAKSEA2601

Airlines

Airlines_IdNameCallsignHeadquarters
1United AirlinesUALChicago
2Delta Air LinesDLAtlanta
3American AirlinesAAFort Worth
4Southwest AirlinesWNDallas
5Alaska AirlinesASSeattle

Employees

Employee_IdFirstNameLastNameDateOfBirthEmailPhoneNumberHireDate
1JohnSmith1980-06-15john.smith@example.com555-12342005-05-15
2JaneDoe1990-08-20jane.doe@example.com555-56782006-06-15
3MichaelJackson1985-10-30michael.jackson@example.com555-90122007-07-15
4EmilyWilliams1995-12-05emily.williams@example.com555-13572008-08-15
5DavidMartin1988-02-12david.martin@example.com555-14152009-09-15