If a student is allowed to have multiple majors and advisers are assigned to multiple students, these would be examples of ________ relationships.
A) M:N
B) N:1
C) 1:1
D) N:M
E) 1:N

Question

Quizplus · Accepted Answer

The relationship between students and majors is many-to-many (M:N) since a student can have multiple majors and a major can have multiple students. Additionally, the relationship between advisers and students is also many-to-many (M:N) since an adviser may have multiple students and a student may have multiple advisers. Therefore, the overall relationship is a combination of two many-to-many relationships, which results in an N:M relationship.

If a Student Is Allowed to Have Multiple Majors and Advisers