You are hired to design a database that keeps the information about an airport, all the airplanes stationed and maintained in it as well as its employees. The relevant information is described below:
a. Every airplane has a registration number, and each airplane is of a specific model.
b. The airport accommodates a number of airplane models, and each model is identified by a model number (eg. AB400) and has a capacity and a weight.
c. A number of technicians and traffic controllers employees work at the airport. You need to store the name, address, phone number, and salary of each employee. You can assume that each employee is uniquely identified by an SSN.
d. Traffic controllers employees only must have an annual medical examination. For each traffic controller, you must store the date of the most recent exam.
e. All airport employees belong to an association. You must store the association membership number of each employee. Each technician is an expert on one of more plane model(s), and his/her expertise may overlap with that of other technicians. This information about technicians must also be recorded.
