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

From: David Cressey <cressey73_at_verizon.net>
Date: Sat, 15 Dec 2007 11:22:40 GMT
Message-ID: <4OO8j.160$L91.153@trndny05>

"-CELKO-" <jcelko212_at_earthlink.net> wrote in message news:7611de79-ad9c-4083-b5de-8ea306d74046_at_i12g2000prf.googlegroups.com...
> >> If teachers are permitted to change their names, then names are not
appropriate keys for teachers. <<
>
> Agreed; this was a skeleton table to demonstrate to the OP that tables
> can have redundant or even overlapping keys to preserve data
> integrity. Tony just gets easily side tracked and I am afraid I tend
> to fall for it myself. Sorry for the thread drift ..
>
> Instead of a teacher's name, we can tattoo a permanent bar code on the
> foreheads of the faculty, using their tax identification number :)

That sounds like something Hitler would have said! Received on Sat Dec 15 2007 - 05:22:40 CST