Some experts suggest that you avoid the use of intelligent keys when designing your data model. They argue that because characteristics can change it violates the rule that the value of a key should not change over the lifetime of each entity instance.

Question

Quizplus · Accepted Answer

Intelligent keys contain meaningful information that can change over time, violating the principle that keys should remain constant to ensure data integrity.

Some Experts Suggest That You Avoid the Use of Intelligent