Consider an E-R diagram where a ternary relationship Works_On exists between…
GPSC College Teaching (CS/IT) 2025
Consider an E-R diagram where a ternary relationship Works_On exists between Employee, Project and Department. If we also need to record a Supervisor for each (Employee, Project, Department) combination, which E-R construct is most appropriate for representing this new requirement and why?
- A.
A new binary relationship between Supervisor and Employee as it simplifies the schema.
- B.
A direct quaternary relationship between Supervisor, Employee, Project and Department as it explicitly links all relevant entities.
- C.
Aggregate the Works_On relationship into a higher-level entity, then create a binary relationship from this aggregated entity to Supervisor to capture the association.
- D.
Generalization of Works_On into a super-entity Work_Detail, then adding Supervisor as an attribute to Work_Detail.
Attempted by 87 students.
Sign up free to check your answer
Sign up freeLoading lesson…

