| id | Name | Years_of_experience |
|---|---|---|
| 1 | John Doe | 10 |
| 2 | Jane Smith | 7 |
| 3 | Alice Johnson | 12 |
| 4 | Bob Brown | 8 |
| 5 | Charlie Davis | 9 |
| id | EmployeeID | Certification_Level |
|---|---|---|
| (→ Employees.id) | ||
| 1 | 1 | Level I |
| 2 | 2 | Level II |
| 3 | 3 | Level III |
| 4 | 4 | Level IV |
| 5 | 5 | Level V |
| id | EmployeeID | Language_proficiency |
|---|---|---|
| (→ Employees.id) | ||
| 1 | 1 | English, Spanish |
| 2 | 2 | English, French |
| 3 | 3 | English, German |
| 4 | 4 | English, Italian |
| 5 | 5 | English, Russian |
| id | Model | Capacity |
|---|---|---|
| 1 | Boeing 747 | 400 |
| 2 | Airbus A380 | 860 |
| 3 | Bombardier CRJ-900 | 84 |
| 4 | Embraer E190 | 96 |
| 5 | Airbus A220 | 124 |
| id | Source | Destination | Departure_Time | Arrival_Time | AircraftID |
|---|---|---|---|---|---|
| (→ Planes.id) | |||||
| 1 | New York | London | 2023-01-01 08:00 | 2023-01-01 11:00 | 1 |
| 2 | Los Angeles | Tokyo | 2023-01-02 08:00 | 2023-01-02 11:00 | 2 |
| 3 | Paris | Dubai | 2023-01-03 08:00 | 2023-01-03 11:00 | 3 |
| 4 | Rio de Janeiro | São Paulo | 2023-01-04 08:00 | 2023-01-04 11:00 | 4 |
| 5 | Cape Town | Johannesburg | 2023-01-05 08:00 | 2023-01-05 11:00 | 5 |
| id | TechnicianID | PlaneID | Date_performed | Work_completed |
|---|---|---|---|---|
| (→ Aviation_Maintenance_Technicians.id) | (→ Planes.id) | |||
| 1 | 1 | 1 | 2023-01-01 | Engine inspection and replacement of filters |
| 2 | 2 | 2 | 2023-01-02 | Landing gear overhaul |
| 3 | 3 | 3 | 2023-01-03 | Wing inspection and repair of minor damage |
| 4 | 4 | 4 | 2023-01-04 | Avionics system upgrade |
| 5 | 5 | 5 | 2023-01-05 | Fuel system cleaning and leak check |