In which of the following cases is the number of tables required to represent the relationship equal to three?

Question

Quizplus · Accepted Answer

In option D, the relationship requires three tables because it has a many-to-many relationship between the tables. One table represents the "Course" entity, another table represents the "Instructor" entity, and the third table represents the relationship between the two entities. This is identified by the presence of a junction or join table that holds the primary keys from the related tables.

In Which of the Following Cases Is the Number of Tables