Given the Tables

question 19

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
• D).
• 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 , SupplierI
• D),.

---

Definitions:

Coupon Rate

The annual interest rate paid by a bond, expressed as a percentage of the face value.

Yield To Maturity

The overall gain expected from a bond, provided it is kept until its due date, including all received interest and the principal amount's reimbursement.

Semi-Annually

Happening biannually, usually once every six months.

Face Value

Face value is the nominal value or dollar value printed on a security or a bond, representing the amount to be repaid at maturity.