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:

African American

A racial or ethnic group in the United States with ancestors from sub-Saharan Africa.

Acculturation

The process of adapting to and adopting aspects of another culture, often occurring when individuals from different cultures come into continuous first-hand contact.

Sustained Firsthand Contact

Direct and ongoing engagement with people, environments, or experiences.

Integration

The process of combining separate parts or elements to form a coherent whole, often used in contexts of social, system, or data consolidation.