You work as a Database Documenter for Tech Perfect Inc. You have a database named Database1
created in Microsoft Office Access 2010. This database contains three tables named Products,
Orders, and Order Details. You want to manage the tables in such a way that each record in the
Orders table will have many records in the Products table and each record in the Products table will
have many records in the Orders table. What should you do to accomplish the task?
A.
Create a many-to-many relationship.
B.
Create a one-to-one relationship.
C.
Create a container-managed relationship.
D.
Create a one-to-many relationship.
Explanation:
In order to accomplish the task, you should create a many-to-many relationship between the Orders
table and the Products table. You can define this relationship by creating two one-to-many
relationships to the Order Details table.
Answer B is incorrect. A one-to-one relationship is created between two tables in which each record
in one table can have only one related record in another table.
Answer D is incorrect. A one-to-many relationship is created between two tables in which a row in
the first table can have one or more matching rows in the second table, but a row in the second
table can have only one matching row in the first table.
Answer C is incorrect. The Microsoft Office Access does not have this kind of relationship.