| id | name | location |
|---|---|---|
| 1 | Office A | New York |
| 2 | Office B | Chicago |
| 3 | Office C | Los Angeles |
| 4 | Office D | Dallas |
| 5 | Office E | Atlanta |
| id | source_type | description |
|---|---|---|
| 1 | Automated_Weather_Station | Collects real-time weather data. |
| 2 | Radar_System | Tracks precipitation and storm systems. |
| 3 | Satellite | Monitors global atmospheric conditions. |
| 4 | Wind_Sensor | Measures wind speed and direction. |
| 5 | Temperature_Sensor | Records ambient temperature. |
| meteo_office_id | data_source_id |
|---|---|
| (→ Meteorological_Offices.id) | (→ Data_Sources.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 3 |
| id | terminal_name | capacity |
|---|---|---|
| 1 | Terminal 1 | 5000 |
| 2 | Terminal 2 | 4500 |
| 3 | Terminal 3 | 4000 |
| 4 | Terminal 4 | 3500 |
| 5 | Terminal 5 | 3000 |
| flight_number | departure_time | arrival_time | destination_airport | airline_company |
|---|---|---|---|---|
| 1 | 2022-12-01 10:00:00 | 2022-12-01 13:00:00 | JFK | American Airlines |
| 2 | 2022-12-01 12:00:00 | 2022-12-01 16:00:00 | ORD | United Airlines |
| 3 | 2022-12-01 14:00:00 | 2022-12-01 18:00:00 | LAX | Delta Airlines |
| 4 | 2022-12-01 16:00:00 | 2022-12-01 20:00:00 | DFW | Southwest Airlines |
| 5 | 2022-12-01 18:00:00 | 2022-12-01 22:00:00 | ATL | Spirit Airlines |