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?

  1. A.

    A new binary relationship between Supervisor and Employee as it simplifies the schema.

  2. B.

    A direct quaternary relationship between Supervisor, Employee, Project and Department as it explicitly links all relevant entities.

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

  4. 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 free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…