GATE CSE 2024 | Set 1 | Question: 10

Question

Let $\mathrm{S}$ be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one of the following $\mathrm{ER}$ diagrams CORRECTLY represents $\mathrm{S}$? 

• A. $\text{(i)}$
• B. $\text{(ii)}$
• C. $\text{(iii)}$
• D. $\text{(iv)}$

Comments

Student is entity not relation , so (a) rejected

Student is not present so (b) rejected

Courses are allocated with Classroom so relation would be there (c) rejected

Ans (d)

---

adding to this there is no project entity given in question  so we can reject b using that as well.

Answer 1

Option D is correct
There's a relationship b/w :

• Instructors (Teaches) courses
• Students (Registration) courses
• Courses (Allocation) classrooms
• Instructors (Guides) students

Link them and you'll get a figure like (iv)
Also obviously : Student, Instructor, Courses and Classroom are all entity

Comments

Entity is denoted by rectangle ( Instructors,students, courses, instructors)

Relationship is denoted by diamond ( teaches,registration,allocation,guides)

Answer 2

Option D

(iv) correctly depicts the above written sentence

Comments

Can u plz explain??

---

just eliminate the option

statement: students register for courses. so here student and course is entity and register is relation which is not depicted in (i) and (ii) option now comes to the (iii) and (iv) option

so (iv) option is correct as statement says "courses are allocated classrooms " so course and classroom entity is in relation with allocation.

Answer 3

Figure number 4 depicts correctly all the realtions correctly.

In figure 1 Student cannot be realation, student has to be an entity.
In figure 2 from no where Project came as an entity.

In figure 3 classrom room is an attribute of course doesn't makes sense

Answer 4

D (iv)

Answer 5

Here is the exact visual representation of the correct ER Diagram layout from option (iv)<!--TgQPHd|[]-->.