Question: Why do we need to create an E-ER model for an ER model? Explain the 'overlap' and 'disjoint' rules of E-ER model Part 2: You

 Why do we need to create an E-ER model for an

Why do we need to create an E-ER model for an ER model? Explain the 'overlap' and 'disjoint' rules of E-ER model Part 2: You are creating a database for a college/university. Develop an E-ER Model with this given information: 1) Two specializations of Person: employee, student 2) Three specializations of Employee: staff, faculty, student assistant Person can be employee and/or student at the same time 3) Two specializations of Student: Graduate, undergraduate student Student assistant Student can ONLY be graduate or undergraduate student, not both at the same time 4) Two specializations of Student assistant: teaching assistant, research assistant .Student assistant can only be teaching or research assistant at the same time, not both Details required: You should show 5 attributes of person, at minimum You should have at least one unique attribute for each subtype entity Clearly show applied 'Overlap' and 'disjoint' rules

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!