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.

2. List all relationships with two entities and an English phrase. There are no ternary relationships. For each relationship state whether it is 1:1, 1:*, or *:*

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

Answer 1

1 and 2 :

E-R in crow's foot model to satisfy the business rules of question with entities with attributes and relationships of cardinalities as per the question 2

3. ER diagram as per the requirements in the question 3 and also complying the given business rules  in Chen model