A primary key for an entity type should never change after it has been assigned,and it should serve no other purpose but to identify that entity.

Question

Quizplus · Accepted Answer

This is one of the fundamental principles of entity-relationship modeling and database design. Changing a primary key can create significant problems with data consistency and referential integrity. Additionally, primary keys should be simple and stable, designed solely for the purpose of identifying unique records in a table. They should not carry additional meaning or be used for other purposes such as sorting or filtering data.

A Primary Key for an Entity Type Should Never Change