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:

1.      List each entity with attributes, showing the primary key of each.

Answer 1

Relationship between Airplane and model is 1:M where participation of Airplane is mandatory one and participation of model is optional many.

Relationship between technician and model is M:N where participation of both the entity is mandatory many.

The relationship between technician and Airplane called Test is 1:M where participation of Technician is optional many while participation of Airplane is mandatory one.

The ER diagram is

Entites along with their primary keys are

1. Airplane - RegistrationNo

2. Model - ModelNo

3. Technician - SSN

4.Owner -(Name, Phone#)

If you have any questions comment down. Please don't simply downvote and leave. If you are satisfied with answer, please? upvote thanks...