The GATE Grind

GATE 2024 CS (CS1) – Question 20

Databases · ER-Model and Database Architecture · 1 mark · Multiple choice

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 for GATE 2024 CS (CS1) question 20
  1. (i)
  2. (ii)
  3. (iii)
  4. (iv)

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (D) (iv)

Explanation

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.