| 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 |