Re: Newbie question about db normalization theory: redundant keys OK?

> Since Roy and I both do our things in the real world of business and
> commerce, I can only assume you must confine yourself to a desk in a
> classroom where real world issues never occur or enter the frame.
> Otherwise, I can make no sense whatsoever of what you wrote.

Really, I guess concurrency avaids whatever database you use.

I guess doing a SELECT ... FROM ... on a Monday and then using that key on a look up on Wednesday without an imutable key does not cause you any problems.

What is this miraculus database called? Perhaps we should stop using all the commerical ones immediately.

PS.. I went to see the Peter Pan pantomine yesterday; so much reminds me of your content....

-- 
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]