Question: 1 . Using ERD for University DB from HW 5 , make needed enhancements to the ERD using the concepts of generalization and specializations. Your

1. Using ERD for University DB from HW 5, make needed enhancements to the ERD using the concepts of generalization and specializations. Your work must be completed in draw.io and use Chens notation covered in class. Once your diagram is complete, export it to .png or .jpeg format and insert it in your homework document. Hand drawn diagrams are not accepted.
a. Improve the design of your Faculty and Student entities to avoid storing duplicate information that describes them as a Person such as name, DOB, SSN, etc.
b. Think how you can store all address information for your DB in one entity to avoid duplication. Both departments and humans (students and faculty have addresses). Assume that each department has only one address but people can have more than one address on file and you need to keep track of their type (primary, secondary, previous, etc).

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!