Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 incomplete, make up reasonable explanations to complete the story. Supply your explanations along with the diagram.

(Scenario) A university keeps information on its constituents and the personal computers (PCs) rented to them. For each person, university ID, name, and phone number are kept. The constituents are employees and students. Each employees hired date and each students 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 the 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

Note: assume that all the attributes described above are mandatory attributes.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions