Let S be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one of the following ER diagrams CORRECTLY represents S?
Diagram (iv) has Instructor–Teaches–Course, Course–Allocation–Classroom, Student–Registration–Course, and Instructor–Guides–Student, all as relationships between entities. Others misuse entities as relationships or add spurious entities like Projects.
More ER-Model and Database Architecture questions
GATE 2024 CS (CS2) Q20– In the context of owner and weak entity sets in the ER (Entity-Relationship) data model,…
GATE 2020 CS Q24– Which one of the following is used to represent the supporting many-one relationships of a…
GATE 2018 CS Q21– In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity…
GATE 2015 CS (CS1) Q48– Consider an Entity-Relationship (ER) model in which entity sets E 1 and E 2 are connected…
GATE 2017 CS (CS2) Q27– Entity types A and B are connected by relationship R with no attributes. When can the…
GATE 2012 CS Q24– For basic ER and relational models, which is incorrect?