Refactoring Databases - Evolutionary Database Design

Replace Surrogate Key With Natural Key

Replace a surrogate key with an existing natural key.



Example

Replace Surrogate Key With Natural Key Example

For more information see page 135 of Database Refactoring