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 |