What is the difference between surrogate keys and natural keys? When would you use each, and what are the implications for data modeling?

Sample answer preview

The choice between surrogate and natural keys has significant implications for database design, performance, and maintenance. Understanding when to use each is a fundamental modeling decision. Natural keys are real-world identifiers that already exist in the business domain.