GATE CS 2024 Set 1 — Question 20

Go beyond PYQs with Success TrackerAI-powered personalised practice and doubt support. Unlimited practice on eligible plans; AI usage limits apply.

MCQ+1 / -0.33EasyRelationshipsER ModelDatabases

Databases → ER Model → Relationships

Last updated 20 August 2026

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?

Correct answer (D) (iv) Solution The specification S consists of four relationships: 1. Instructors teach courses : A relationship between the Instructor and Course entities. 2. Students register for courses : A relationship between the Student and Course entities. 3. Courses are allocated classrooms : A relationship between the Course and Classroom entities. 4. Instructors guide students : A relationship between the Instructor and Student entities. Let's analyze the given diagrams: Diagram (i) : The Allocation relationship is ternary, connecting Course, Classroom, and Student . This implies students are involved in the allocation of classrooms, which contradicts the specification. Also, there is no direct Registration relationship between Student and Course . Diagram (ii) : The Guides relationship connects Instructor to an entity labeled Projects (or similar), not Student . This contradicts the specification "Instructors guide students". Diagram (iii) : The Registration relationship connects Student to the Allocation relationship (associative entity), rather than directly to Course . This implies students register for a specific allocation, which is not the standard interpretation of "register for courses". Diagram (iv) : Teaches connects Instructor and Course . Registration connects Student and Course . Allocation connects Course and Classroom . Guides connects Instructor and Student . This diagram correctly models all four specifications using binary relationships between the appropriate entities. Therefore, diagram (iv) is the correct representation. Turn this into a strength. Explore AI-powered practice and doubt support with Success Tracker.

Review answer and solution without JavaScript

Interactive answer checking needs JavaScript. The published solution is available below.

Correct answer (D) (iv) Solution The specification S consists of four relationships: 1. Instructors teach courses : A relationship between the Instructor and Course entities. 2. Students register for courses : A relationship between the Student and Course entities. 3. Courses are allocated classrooms : A relationship between the Course and Classroom entities. 4. Instructors guide students : A relationship between the Instructor and Student entities. Let's analyze the given diagrams: Diagram (i) : The Allocation relationship is ternary, connecting Course, Classroom, and Student . This implies students are involved in the allocation of classrooms, which contradicts the specification. Also, there is no direct Registration relationship between Student and Course . Diagram (ii) : The Guides relationship connects Instructor to an entity labeled Projects (or similar), not Student . This contradicts the specification "Instructors guide students". Diagram (iii) : The Registration relationship connects Student to the Allocation relationship (associative entity), rather than directly to Course . This implies students register for a specific allocation, which is not the standard interpretation of "register for courses". Diagram (iv) : Teaches connects Instructor and Course . Registration connects Student and Course . Allocation connects Course and Classroom . Guides connects Instructor and Student . This diagram correctly models all four specifications using binary relationships between the appropriate entities. Therefore, diagram (iv) is the correct representation.

Continue learning with Success Tracker

A step still unclear? Work through it with support

Use Success Tracker to ask about the reasoning, then try another GATE CS question to check your understanding.

AI-powered practice· Unlimited practice on eligible plans

PYQs with solutions: Attempt available previous-year questions, then compare your reasoning with the worked solution. Coverage varies by stream.
Practice that adapts: Choose a topic, work on weaker areas and bookmark questions to revisit. Your attempts feed your progress tracking.
AI doubt support: Ask follow-up questions about a step or concept while practising, instead of stopping at the final answer.

Unlimited practice is available on eligible plans. Free practice and AI usage have limits; check the current plan allowances before choosing.

Start with a free account View plans and allowances

This page stays readable without an account. AI responses can be wrong; check them against the solution and source material.

GATE CS 2024 Set 1 — Question 20

Question

Correct answer

Solution

A step still unclear? Work through it with support

More questions on ER Model