Consider the Following Diagram

Multiple Choice

Consider the following diagram.Which of the following best describes how the relationship between Sales Orders and Products will be implemented in the resulting database?

A) A new table will be created that contains both Sales Order ID and Product ID as its composite primary key.
B) The Product ID will be included as a foreign key in the Sales Orders table.
C) The Sales Order ID will be included as a foreign key in the Products table.
D) The Quantity Ordered field will be included as a foreign key in the Products table.