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:

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 *:*

Answer 1

Airport Authority

Airplane registration number: Every flight have unique registration number which is important to identify the airplane uniquely . Registration number of the airplane given by the associated company Airplane registration number may includes company's name tag or some other copyright mark to show that which company is associated with the specific airplane. Example:- Airplane registration can be like this- AirBusRegis122002

Airplane Model:- Airplane model refers to the quality or updates in the airplanes model can be divided into the different categories such as Long distance flights and short distance flights model.

it can be categories like model 2002 to model 2012 , 2012 to model present (2020)etc

=> Airport has number of airplane model and each airplane identify by its own model number and its capacity and weight.

Airport is associated with some different companies therefore these associated company's airplane can be used by the Airport. All these airplane are of different model which carried by the same airport. these are identifies by unique model number and

Capacity:- In this capacity refers to holding the number of people in the airplane. such as how many seats are available in the airplane capacity of the plane is depands upon the number of passengers hold by the airplane according to the passengers we can say this is large capacity airpalne or middle and low capacity airplane.

example:- if a airplane can hold 250 people = Large capacity

Weight:- Weight refers to the maximum takeoff weight of flight. It includes Airplane weight, total people, airplane's fuel,cargo,crew, Total weight of flight defines the airplane weight.

Airplane Owner:- Airplane has owner whose identified by its name and contact number through this the owner of the specific airplane can be identify easily.

Example:- Airplane : A67Plane

Owner : Mr. Alein

Contact : 041-7431

Technician Expert:- Number of Employees works at airport In these "Technician" works at airport to test the airplane time to time they check and test the technical faults of the airplan and repair the fault. airport authority need to store all the records of each and every technician uniquely whose working there.

To identify each technician uniquely there is need to make list of all technician this list includes their NAME , SSN(Social Securty Number) , ADDRESS, PHONE NUMBER AND SALARY.

Example:- Technician List

Name Ssn Address Phn no. Salary

Alen A12 Cicago +71876 $500

Sen S22 Maxico -2154 $400

It is possible that both Alen and Sen are expert on different airplane model and it is also possible that both are expert on same airplane model.

FAA(Federal Aviation Administration):-

Requires the airport to carry out test of all airplanes. Testing is a process of checking the airplane and functioning whether it's parts are faulty and fault free if there's fault found then fault will be repair or the faulty parts will replace by new parts. Technician do testing of airplanes and also note the testing date of airplane ,time of testing also recorded by the technician and maintance of precent score of testing.

example:-  

Airplane test Date of test Time of test precent score

Airbus1 12-02-2020 6Hours 50%

Airbus2 10-11-2020 5hours 60%

List of Relationship with Entities:-

Airport - Airplane,Employee

Airplane- Airplane Owner

Employee- Technician,FAA expert