In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of surrogate keys.
Step-by-step explanation:
A surrogate key is a unique identity as an object or entity. It is used as an object in the database and as an entity in the modern world. Surrogate key is not a natural key hence it cannot be derived from application data.
Advantages of using surrogate key:
- They are unique
- They have uniform rules
- It allows unlimited values
- It stands the test of time