Subject Db Design opinions sought - Lookup tables and surrogate PKs
Author Rob Schuff
greetings folks,

we are having a spirited discussion at a work about lookup table and whether
or not they should have a surrogate primary (integer) or whether its better
to just use the lookup value (or an uppercase'd copy of it) as the primary
key. I personally have been on both sides of the fence before (normalize to
the max or be somewhat pragmatic). Anybody care to share their opinions?