Suppose a Products Table Has a ProductID Primary Key,and a Related

question 7

Multiple Choice

Suppose a Products table has a ProductID primary key,and a related Sales table has a ProductID foreign key.Which of the following would cause a concern?

• A)The Sales table has several records with ProductID 79,and the Products table has exactly one record with ProductID 79.
• B)The Products table has exactly one record with ProductID 43,and the Sales table has no records with ProductID 43.
• C)The Sales table has several records with ProductID 61,and the Products table has no records with ProductID 61.
• D)The Products table has exactly one record with ProductID 87,and the Sales table has only one record with ProductID 87.

---

Definitions:

Face Value

The nominal or dollar value printed on a financial instrument, such as a bond or stock certificate.

Callable Bonds

Bonds that can be redeemed by the issuer before their maturity date at a specified call price.

Noncallable Bonds

Bonds that cannot be redeemed by the issuer before their maturity date.

Callable Bonds

Bonds that can be redeemed by the issuer prior to their maturity date, usually at a predetermined price.