Given the Tables PRODUCT (ProductID,Description,Cost)

question 37

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, SupplierID ) SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductI
• C) PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber) PRODUCT_SUPPLIER (ProductID, SupplierI
• D) .
• D) PRODUCT (ProductID, Description, Cost, SupplierI
• D) SUPPLIER (SupplierID, ContactName, PhoneNumber).
• E) PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber) PRODUCT_SUPPLIER (ProductID, SupplierID )

---

Definitions:

Habit

A routine behavior that is repeated regularly and tends to occur subconsciously.

Incentive

Something that motivates or encourages someone to do something.

Biological Deficiency

A condition where an organism lacks a substance or element necessary for its growth, maintenance, or functioning.

Achievement

Successfully reaching a goal through effort, skill, or courage, often recognized by some form of acknowledgment or reward.