Nature key or surrogate key (country table)?
Posted on 2009-02-22
This has probably been discuss a number of times "nature keys vs surrogate" etc
I have an original database design where the previous architecture used a mix of both nature keys and surrogate keys
The database is currently being redesigned, all tables have been converted to "surrogate" keys
Except for the country, currency, and state table these 3 tables are still using nature keys (makes life simple)
However i'm thinking we "should" convert them all to surrograte keys aswell
but the real question is, is there really a point?
-a country change name?
-a currency change currency code?
-a state change name?
It can happen! and has! (hence the reason considering having surrogate keys in all tables).