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 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
Get step-by-step solutions from verified subject matter experts
