The officials at Essendon Airport have decided that all information related to the airport should be organised using a DBMS, and youve been hired to design the database. Your first task is to organise the information about all the airplanes that are stationed and maintained at the airport. The relevant information is as follows:

1. Every airplane has a registration number, and each airplane is of a specific model.
2. The airport accommodates a number of airplane models, and each model is identified by a model number (e.g., DC-10) and has a capacity and a weight.
3. A number of technicians work at the airport. You need to store the name, TFN (Tax File Number), address, phone number, and salary of each technician.
4. Each technician is an expert on one or more plane model(s), and his or her expertise may overlap with that of other technicians. This information about technicians must also be recorded.
5. The airport has a number of tests that are used periodically to ensure that airplanes are still airworthy. Each test has a Civil Aviation Safety Authority (CASA) test number, a name, and a maximum possible score.
6. The CASA requires the airport to keep track of each time that a given airplane is tested by a given technician using a given test. For each testing event, the information needed is the date, the number of hours the technician spent doing the test, and the score that the airplane received on the test. Consider the following ER model developed to represent the Essendon airport operations above Map this ER diagram into a relational database schema, following the process shown explained on the preparation activities page. Insert your relational database schemas, including appropriate annotations for primary and foreign keys