## Employees

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

## Aviation_Maintenance_Technicians

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

## Flight_Attendants

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

## Planes

id | Model | Capacity
--- | --- | ---
1 | Boeing 747 | 400
2 | Airbus A380 | 860
3 | Bombardier CRJ-900 | 84
4 | Embraer E190 | 96
5 | Airbus A220 | 124

## Flights

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

## Maintenance_Records

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