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

On 14 Dec, 12:16, "Tony Rogerson" <tonyroger..._at_torver.net> wrote:
> > I'll remember this. It is a great example of why no one should bother
> > reading your blog.
>
> Oh, I see Roy; you agree with Celko's design.
>
> Interesting....
>
> --
> Tony Rogerson, SQL Server MVPhttp://sqlblogcasts.com/blogs/tonyrogerson
> [Ramblings from the field from a SQL consultant]http://sqlserverfaq.com
> [UK SQL User Community]

Tony,

You didn't specify any reason why you thought Joe's design was wrong. There is no obvious reason for confusion just because a teacher's name changes - at least not as far as the data model is concerned. Users of the data need a way to identify their teacher but how would an "artificial key" help? I never knew any of my teachers as 1234.

--
David Portas