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:

Interest Rate

The percentage at which interest is calculated on the principal of a loan or deposit over a specific period of time.

Payments

The act of transferring money or something of value from one party to another in exchange for goods, services, or to fulfill a legal obligation.

Borrowed

Refers to funds that have been taken from another party under the agreement that they will be repaid at a later date, often with interest.

Semi-Annual Compounding

Interest calculation on a financial instrument twice a year, adding the interest amount to the principal sum each time.