When selecting an identifier,one should choose a candidate key that will not change its value over the life of each instance of the entity type.

Question

Quizplus · Accepted Answer

This is true. An identifier (or primary key) should uniquely identify each instance of an entity type and should not be subject to change. If the candidate key changes, it can cause issues with data integrity and could affect related entities.

When Selecting an Identifier,one Should Choose a Candidate Key That