Consider the Following Diagram

question 32

Short Answer

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:

Secondary Market

A market where investors buy and sell securities they already own, typically through a brokerage.

Primary Market

The market where new securities are issued and bought directly from the issuing company, facilitating capital raising.

Auction Market

A marketplace where buyers and sellers enter bids and offers simultaneously; prices are determined through direct interaction of supply and demand.

Dealer Market

A financial market mechanism in which dealers buy and sell securities for their own accounts.