Question: make needed enhancements to the ERD using the concepts of generalization and specializations. Your work must be completed in draw.io and use Chen's notation
make needed enhancements to the ERD using the concepts of generalization and specializations. Your work must be completed in draw.io and use Chen's 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). Faculty D Faculty N WorksFor FacultyName Department DectID DeptName Teaches Offers N Section D M MaxEnrollment Section N Belongs To Course Requires Prerequisite M N Advise CourselD CourseName CreditHours Enroll Grade Offeredin N Student Student D StudentName Semester GPA FirstName LastName SemesterCode StartDate EndDate
Step by Step Solution
3.43 Rating (156 Votes )
There are 3 Steps involved in it
Answer ER diagram ... View full answer
Get step-by-step solutions from verified subject matter experts
