FlightID | DepartureTime | Destination | Duration |
---|---|---|---|
1 | 2023-04-01 08:00:00 | New York | 6 |
2 | 2023-04-01 09:00:00 | Chicago | 7 |
3 | 2023-04-01 10:00:00 | Los Angeles | 8 |
4 | 2023-04-01 11:00:00 | Miami | 7 |
5 | 2023-04-01 12:00:00 | Houston | 6 |
WeatherID | Description | Temperature |
---|---|---|
1 | Clear Skies | 75.0 |
2 | Rainy | 65.0 |
3 | Foggy | 70.0 |
4 | Stormy | 80.0 |
5 | Sunny | 85.0 |
IssueID | TypeOfIssue | Severity |
---|---|---|
1 | Engine Trouble | High |
2 | Landing Gear Problem | Medium |
3 | Electrical System Failure | Low |
4 | Brakes Issues | Medium |
5 | Fire Extinguisher Missing | High |
AircraftID | Model | Capacity | CurrentAirport |
---|---|---|---|
1 | Boeing 747 | 300 | JFK |
2 | Airbus A380 | 400 | LAX |
3 | Bombardier CRJ700 | 50 | ORD |
4 | Embraer E190 | 70 | MIA |
5 | Beechcraft King Air C90 | 8 | HOU |
PilotID | Name | LicenseNumber | ExperienceYears |
---|---|---|---|
1 | John Smith | ABCD1234 | 10 |
2 | Jane Doe | EFGH5678 | 8 |
3 | Tom Johnson | IJKL9012 | 5 |
4 | Emily Williams | LMNOP3456 | 7 |
5 | David Brown | QRST7890 | 12 |
RecordID | AircraftID | LastMaintenanceDate |
---|---|---|
(→ Aircraft.AircraftID) | ||
1 | 1 | 2022-04-01 00:00:00 |
2 | 2 | 2021-04-01 00:00:00 |
3 | 3 | 2022-03-01 00:00:00 |
4 | 4 | 2021-04-01 00:00:00 |
5 | 5 | 2022-04-01 00:00:00 |
StatusID | FlightID | WeatherID | IssueID | AircraftID | PilotID | RecordID | StatusDescription |
---|---|---|---|---|---|---|---|
(→ Flight.FlightID) | (→ Weather.WeatherID) | (→ Mechanical.IssueID) | (→ Aircraft.AircraftID) | (→ Pilot.PilotID) | (→ MaintenanceRecord.RecordID) | ||
1 | 1 | 1 | 1 | 1 | 1 | 1 | Cancelled - Bad Weather & Engine Trouble |
2 | 1 | 2 | 2 | 1 | 2 | 2 | Delayed - Rainy & Landing Gear Problem |
3 | 2 | 3 | 3 | 2 | 3 | 3 | On Time - Foggy & Electrical System Failure |
4 | 3 | 4 | 4 | 3 | 4 | 4 | Cancelled - Stormy & Brakes Issues |
5 | 4 | 5 | 5 | 4 | 5 | 5 | Postponed - Sunny & Fire Extinguisher Missing |