Given the Tables PRODUCT (ProductID,Description,Cost)

question 32

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

---

Definitions:

Accounts Receivable

Money owed to a company by its clients or customers for goods or services that have been delivered but not yet paid for.

Accounts Payable

Money owed by a company to its creditors for goods and services that have been delivered but not yet paid for.

Accounting Equation

A fundamental principle in accounting that states assets equal liabilities plus owner's equity.

Equipment

Physical assets used in the operation of a business, such as machinery, computers, and furniture.