Skip to content
GATEiit

GATE CSE 2024 Session 1 Q20: ER diagram for instructors, courses, students and classrooms

Question

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?

Four ER diagrams (i) to (iv). (i): Student is a relationship and Registration an entity. (ii): Guides links Instructor to a Projects entity, with no Student. (iii): Classroom is joined directly to Course and Allocation hangs off Course alone. (iv): entities Instructor, Course, Classroom, Student with relationships Teaches (Instructor–Course), Allocation (Course–Classroom), Registration (Course–Student) and Guides (Instructor–Student)
Tap the figure to enlarge

Try it: multiple choice: exactly one correct option

Select one option
Wrong answer costs 1/3 mark in GATE.
Show answer and explanation

Answer: D (official GATE 2024 final answer key)

Concept used: Nouns become entity sets (rectangles) and verbs become relationship sets (diamonds).

First step: List the entities (Instructor, Course, Student, Classroom) and the four relationships, then check each diagram for exactly these.

Full step-by-step solution

Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.

Share this question

WhatsAppDownload image

Source: official GATE 2024 Session 1 CS question paper and final answer key, organised by IISc Bangalore. Question paper · Answer key

More Databases PYQs

PracticePractise Databases questions →Full paperAll GATE CSE 2024 Session 1 questions →