id | City | Coordinates | IATA_Code | ICAO_Code | Altitude |
---|---|---|---|---|---|
(→ Flights.IATA_Departure) | (→ Flights.ICAO_Arrival) | ||||
1 | New York | 40.641798,-73.942208 | JFK | KJFK | 12 |
2 | Los Angeles | 34.052235,-118.243683 | LAX | KLAX | 30 |
3 | Chicago | 41.878113,-87.629799 | ORD | KORD | 601 |
4 | Dallas | 32.782812,-96.802623 | DFW | KDFW | 465 |
5 | Miami | 25.761703,-80.191797 | MIA | KMIA | 10 |
Flight_ID | Departure_Time | Arrival_Time | Duration | Seats | IATA_Departure | ICAO_Arrival | Price | ForeignKey_Airline |
---|---|---|---|---|---|---|---|---|
(→ Airports.IATA_Code) | (→ Airports.ICAO_Code) | (→ Airlines.Airlines_Id) | ||||||
1 | 2023-01-01 08:00:00 | 2023-01-01 12:00:00 | 180 | 250 | JFK | KATL | 250 | 1 |
2 | 2023-01-02 09:00:00 | 2023-01-02 13:00:00 | 180 | 250 | LAX | KSFO | 260 | 2 |
3 | 2023-01-03 10:00:00 | 2023-01-03 14:00:00 | 180 | 250 | ORD | KPHX | 240 | 3 |
4 | 2023-01-04 11:00:00 | 2023-01-04 15:00:00 | 180 | 250 | DFW | KEWR | 250 | 4 |
5 | 2023-01-05 12:00:00 | 2023-01-05 16:00:00 | 180 | 250 | MIA | KSEA | 260 | 1 |
Airlines_Id | Name | Callsign | Headquarters |
---|---|---|---|
1 | United Airlines | UAL | Chicago |
2 | Delta Air Lines | DL | Atlanta |
3 | American Airlines | AA | Fort Worth |
4 | Southwest Airlines | WN | Dallas |
5 | Alaska Airlines | AS | Seattle |
Employee_Id | FirstName | LastName | DateOfBirth | PhoneNumber | HireDate | |
---|---|---|---|---|---|---|
1 | John | Smith | 1980-06-15 | john.smith@example.com | 555-1234 | 2005-05-15 |
2 | Jane | Doe | 1990-08-20 | jane.doe@example.com | 555-5678 | 2006-06-15 |
3 | Michael | Jackson | 1985-10-30 | michael.jackson@example.com | 555-9012 | 2007-07-15 |
4 | Emily | Williams | 1995-12-05 | emily.williams@example.com | 555-1357 | 2008-08-15 |
5 | David | Martin | 1988-02-12 | david.martin@example.com | 555-1415 | 2009-09-15 |