Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 Faculty D Faculty N WorksFor FacultyName Department DectID DeptName Teaches Offers N Section D M 

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

Step: 1

Answer ER diagram ... 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_2

Step: 3

blur-text-image_3

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions

Question

Graph one period of each function. y = 4 cos x

Answered: 1 week ago