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 |