Given the Tables PRODUCT (ProductID,Description,Cost)

question 43

Multiple Choice

Given the tables
PRODUCT (ProductID,Description,Cost)
SUPPLIER (SupplierID,ContactName,PhoneNumber)
As shown in the figure below,which of the following would represent the correct placement of foreign keys?

• A) PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber)
• B) PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductI
• C) PRODUCT (ProductID, Description, Cost, SupplierI
• D) SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductI
• D) PRODUCT (ProductID, Description, Cost, ContactName) SUPPLIER (SupplierID, ContactName, PhoneNumber)
• E) PRODUCT (ProductID, Description, Cost, SupplierI
• D) SUPPLIER (SupplierID, ContactName, PhoneNumber)

---

Definitions:

Maximum Price

A price ceiling set by a governing body meant to control the maximum price that can be charged for a product or service, often implemented to prevent prices from reaching levels considered too high for consumers to afford.

Equilibrium Price

The price at which the quantity of a good supplied is equal to the quantity of the good demanded.

Price Ceiling

A legal maximum price that can be charged for a good or service, intended to protect consumers.

Price Ceiling

A legally imposed maximum price on goods or services, intended to protect consumers from high costs.