Question

A certain airport authority wants to organize some of the data associated with the airport. The relevant information is as follows:

• Every airplane has a registration number and each airplane is of a specific model
• The airport accommodates a number of airplane models and each model is identified by a model number and has a capacity and weight
• Each airplane has an owner identified by name and contact phone number.
• A number of technicians work at the airport. You need to store the name, SSN, address, phone number and salary of each technician
• Each technician is an expert on one or more plane models. Multiple technicians may be experts on the same model.
• The FAA requires the airport to carry out tests of all airplanes. The test is carried out by a technician and must record the date of the test, the number of hours for the test and the percent score.

Create an E-R by completing the following tasks:

3. Draw an ER diagram. You should include entities (rectangles), relationships, arrows and multiplicities but you can omit the attributes.

Answer 1

Entity along with their primary key is

1. Airplane - RegistrationNo

2. Model - ModelNo

3. Technician - SSN

If you have any questions comment down and please? upvote thanks