| FlightID | DepartureTime | Destination | Origin | FlightNumber | Type | AirlineID |
|---|---|---|---|---|---|---|
| (→ Airlines.AirlinesID) | ||||||
| 1 | 2023-01-01 08:00 | New York | Los Angeles | AA123 | Boeing 737 | 1 |
| 2 | 2023-01-01 10:00 | Chicago | Miami | UA678 | Boeing 747 | 2 |
| 3 | 2023-01-01 12:00 | Dallas | Atlanta | DL987 | Airbus A320 | 3 |
| 4 | 2023-01-01 14:00 | Philadelphia | Phoenix | SW456 | Bombardier Q400 | 4 |
| 5 | 2023-01-01 16:00 | San Francisco | Honolulu | JB234 | Boeing 787 | 5 |
| AirlinesID | Name |
|---|---|
| 1 | American Airlines |
| 2 | United Airlines |
| 3 | Delta Airlines |
| 4 | Southwest Airlines |
| 5 | JetBlue Airlines |
| FacilityID | Description |
|---|---|
| 1 | Free WiFi access for passengers. |
| 2 | Business center with printing services. |
| 3 | Kids play area for families. |
| 4 | VIP lounge for premium customers. |
| 5 | Currency exchange services. |
| DepartureID | FacilityID |
|---|---|
| (→ Flights.FlightID) | (→ Facilities.FacilityID) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| ArrivalID | FacilityID |
|---|---|
| (→ Flights.FlightID) | (→ Facilities.FacilityID) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |