3. |
How does a many-to-many relationship differ from the other two kinds of relationships?
Please select the best answer.
|
|
A. |
Primary key fields are used for both sides of the relationship. |
|
B. |
Three tables are used instead of two tables. |
|
C.
|
You can’t use referential integrity.
|
|
D. |
No primary key fields are used.
|
|
The correct answer is B. The fact is that three tables are used to create a many-to-many relationship, whereas the other two types of relationships only use two tables. Choice A is incorrect because the one-to-one relationship is the only relationship that uses only primary key fields. Choice C is wrong because you can use referential integrity with many-to-many relationships. Choice D is incorrect because both primary and foreign key fields are used to make up a many-to-many relationship.
|