Refactoring Databases - Evolutionary Database Design

Introduce Surrogate Key

Replace an existing natural key with a surrogate key.



Example

Introduce Surrogate Key Example

For more information see page 85 of Database Refactoring