Surrogate versus Natural Keys

Hi Tom, The project I'm currently working on has the DB design rule that all tables must have a surrogate key. This is the case even if a perfectly good natural key exists. The primary motivation appears to be that of join efficiency by removi...

Read More...

---