make needed enhancements to the ERD using the concepts of generalization and specializations. Your work must...

  

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Answer ER diagram ... View the full answer