Consider the Following Diagram

question 31

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.

---

Definitions:

Trusted Advisor

A role or relationship in which an individual or organization provides expert advice and guidance in a particular area, earning high levels of trust from clients.

Missionary Salespeople

Sales representatives whose primary role is to promote the company’s products indirectly by educating potential customers, rather than directly selling the product.

Delivery Salespeople

Individuals who both deliver goods and generate sales, often directly to the customer's location.

Stocking Shelves

The process of replenishing retail or warehouse shelf space with goods to ensure products are available for purchase or distribution.