Which of the Following Properties Should Be Satisfied When the Identifier

question 103

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.

---

Definitions:

Economic Profits

Profits or losses calculated by considering both explicit costs, such as direct expenses, and implicit costs, like opportunity costs.

Arbitrage Opportunity

The opportunity to buy an asset at a low price in one market and sell it for a higher price in another, exploiting price discrepancies.

Investment Portfolio

Set of securities chosen by an investor.

Sure Profit

A guaranteed financial gain with no risk of loss, often considered unrealistic in most trading or investment scenarios.