Let S be the specification: “Instructors teach courses. Students register for…
2024
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?
- A.
(i)
- B.
(ii)
- C.
(iii)
- D.
(iv)
Attempted by 548 students.
Show answer & explanation
Correct answer: D
Key idea: represent each noun as an entity (rectangle) and each verb as a relationship (diamond) that connects the appropriate entities.
From "Instructors teach courses": create a Teaches relationship (diamond) between the Instructor and Course entities (rectangles).
From "Students register for courses": create a Registration relationship (diamond) between the Student and Course entities.
From "Courses are allocated classrooms": create an Allocation relationship (diamond) between the Course and Classroom entities.
From "Instructors guide students": create a Guides relationship (diamond) between the Instructor and Student entities.
Therefore, the correct diagram is the one that shows Instructor, Course, Student and Classroom as rectangles and has four diamonds connecting the pairs as listed above. That diagram matches the specification precisely.
A video solution is available for this question — log in and enroll to watch it.