The _____ relationship should be rare in any relational database design.
A) 1:1
B) 1:M
C) M:1
D) M:N

Question

Quizplus · Accepted Answer

A 1:1 relationship is basically the same as having all the attributes in one table. It can cause redundancy and data inconsistency issues. Therefore, it should be avoided if possible. M:N relationships can also be problematic and sometimes need to be resolved using a junction table, but they may be necessary in certain cases. The 1:M and M:1 relationships are common and necessary in most database designs.

The _____ Relationship Should Be Rare in Any Relational Database