> There are two ways I would answer this. The first says that email
> address isn't a natural key -- it doesn't uniquely define a person any
> more than hair color does. The second is that the natural key hasn't
> changed, the entity -- a mailbox on a mail server -- has changed.
Absolutely - so we need to use something that won't change - an artificial
key.
--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
Received on Fri Dec 14 2007 - 12:14:41 CST
