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…

Question

Options

• ACreate a many-to-many relationship.
• BCreate a one-to-one relationship.
• CCreate a container-managed relationship.
• DCreate a one-to-many relationship.

• A
  79% (34)
• B
  12% (5)
• C
  7% (3)
• D
  2% (1)

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.

No community discussion yet for this question.