Which of the Following Properties Should Be Satisfied When the Identifier

question 227

Multiple Choice

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?

• A) The value of the key must uniquely identify every row in the relation.
• B) The key should serve as a foreign key in at least two other relations.
• C) The key must be a composite of a primary key and a secondary key.
• D) The key should be an intelligent key.
• E) The key should allow for null values.

---

Definitions:

Net Present Value

A financial metric used to assess the value of an investment by calculating the present value of expected future cash flows minus the initial investment cost.

Current Value

The present monetary or market worth of an asset or investment.

Interest Rate

The cost of borrowing money, expressed as a percentage of the total amount loaned, paid by borrowers to lenders.

Present Value

The contemporary valuation of an anticipated sum of money or cash flow sequence, based on a given return rate.