Question: Develop EER diagram in ERDPlus for a small-private-airport database; the database is used to keep track of airplanes, their owners, airport employees, and pilots. From

Develop EER diagram in ERDPlus for a

Develop EER diagram in ERDPlus for a small-private-airport database; the database is used to keep track of airplanes, their owners, airport employees, and pilots. From the requirements for this database, the following information was collected: Each airplane has a registration number, is of a particular plane type, and is stored in a particular hangar. Each plane type has a model number, a capacity, and a weight. Each hangar has a number, a capacity, and a location. The database also keeps track of the owners of each plane and the employees who have maintained the plane. For each relationship airplane and owner we keep track of the purchase date. For each maintenance service by an employee we keep to a service record. Each plane undergoes maintenance service many times; hence, it is related by to a number of service records. A service record includes as attributes the date of maintenance, the number of hours spent on the work, and the type of work done (i.e. work code). You may use a weak entity type to represent airplane's maintenance service, because the airplane registration number is used to identify a service record. An owner is either a person or a corporation. Your will want to keep track of two types of employees and pilots. Each pilot has specific attributes license number and restrictions; each employee has specific attributes salary and shift worked. All persons in the database have data kept on their Social Security number, name, address, and telephone number. For corporations, the data kept includes name, address, and telephone number. The database also keeps track of the types of planes each pilot is authorized to fly and the types of planes each employee can do maintenance work on

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!