Subject Table

Department Table

-Refer to the tables in Q2.What best describes the relationship between the entities Subject and Lecturer?
A)A lecturer can teach no subjects but may also teach many subjects
B)A lecturer always teaches at least one subject
C)A lecturer always teaches only one subject
D)A lecturer can,but does not have to,teach only one subject

Question

Subject Table
  
Department Table
 
-Refer to the tables in Q2.What best describes the relationship between the entities Subject and Lecturer?
A)A lecturer can teach no subjects but may also teach many subjects 
B)A lecturer always teaches at least one subject 
C)A lecturer always teaches only one subject 
D)A lecturer can,but does not have to,teach only one subject

Quizplus · Accepted Answer

The relationship between Subject and Lecturer is a many-to-many relationship, meaning that a single lecturer can teach multiple subjects and a single subject can be taught by multiple lecturers. Therefore, a lecturer can teach multiple subjects, and does not have to only teach one subject. Choice A is incorrect as it suggests that a lecturer can teach no subjects, which is not possible in this relationship. Choice B is incorrect as it suggests that a lecturer always teaches at least one subject, which is not necessarily the case. Choice C is incorrect as it suggests that a lecturer always teaches only one subject, which is also not necessarily the case.

Subject Table Department Table