Plausability of natural key as primary key
If you have a field in a table that is a natural key and meets all the criteria for a Primary key, is it advisable to use that natural key as your Primary? Or is it a better idea to assign a surrogate key (i.e. autonumber for TrainingProgramID instead of using TrainingProgramName)? Thanks in advance [...]

Answer Question   |  March 31, 2009  12:08 PM
Natural Keys, Primary keys, Surrogate Keys