You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. You are designing the database schema of the application. The database schema is as shown in the exhibit. (Refer to the Exhibit.)
You need to ensure that the design meets the following requirements:
The database contains no duplicate data.
A category can contain zero or more products.
Each product can be associated with zero or more categories.
What should you do?
A.
Create a CategoryID column in the Products table.
Create a foreign key constraint from the Products table to the Categories table on CategoryID.
B.
Create a ProductID column in the Categories table.
Create a foreign key constraint from the Categories table to the Products table on ProductID.
C.
Create a CategoryID column in the Products table.
Create a foreign key constraint from the Products table to the Categories table on CategoryID.
Create a ProductID column in the Categories table.
Create a foreign key constraint from the Categories table to the Products table on ProductID.
D.
Create a ProductsCategories table that includes the ProductID and CategoryID columns.
Create a foreign key constraint from the ProductsCategories table to the Products table on ProductID.
Create a foreign key constraint from the ProductsCategories table to the Categories table on CategoryID.
Create a compound primary key on the ProductsCategories table that includes the ProductID and CategoryID columns.