Question: Create an EERD using generalization/specialization and aggregation based on the scenario below. If you discover while drawing the diagram that the scenario is incomplete, make

 Create an EERD using generalization/specialization and aggregation based on the scenario
below. If you discover while drawing the diagram that the scenario is

Create an EERD using generalization/specialization and aggregation based on the scenario below. If you discover while drawing the diagram that the scenario is incomplete, make up reasonable explanations to complete the story. Supply your explanations along with the diagram. Note: (Scenario) Morehead State University keeps information on its constituents and the personal computers (PCs) rented to them. For each person, MSU ID, name, and phone number are kept. The constituents are employees and students. Each employee's hired date and each student's major are also kept. Employees consist of administrators and professors. Students consist of undergraduates and graduates. The following information are a unique attribute of each type of person: Administrator: Admin_Title Professor: Prof Rank Undergraduate: Under_Hours Graduate: Grad_Thesis Each employee rents a personal computer (PC) from Morehead State University for his/her work. For each PC, price information is kept. Each PC has two components: hardware and software. The following are the attributes of hardware and software: Hardware: Unit_ID, Speed Software: Serial_No, Developer

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 Databases Questions!