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.

Question

Quizplus · Accepted Answer

When the identifier of the entity type becomes the primary key of the corresponding relation, it should satisfy the property that the value of the key must uniquely identify every row in the relation. This is because the primary key is used to uniquely identify each record in the relation, and it must be unique and non-null for each record. The other properties mentioned in the options are not necessarily required when the identifier becomes the primary key.

Which of the Following Properties Should Be Satisfied When the Identifier