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

"Tony Rogerson" <tonyrogerson_at_torver.net> wrote in message news:fjtdb3$h58$1$8302bc10_at_news.demon.co.uk...
>> CREATE TABLE Schedule
>> (teacher VARCHAR(15) NOT NULL,
>> class CHAR(15) NOT NULL,
>> room INTEGER NOT NULL,
>> period INTEGER NOT NULL,
>> PRIMARY KEY (teacher, class, room, period));
>>
>> That choice of a primary key is the most obvious one -- use all the
>> columns. Typical rows would look like this:
>>
>> ('Mr. Celko', 'Database 101', 222, 6)
>
> And half way through term the teacher changed their name to 'Mrs Bunting'
> and now everybody is confused!
>
> Great example of why you should use an artificial key, I'll remember your
> example for a blog entry I'm writing.

I'll remember this. It is a great example of why no one should bother reading your blog.

Roy Received on Fri Dec 14 2007 - 02:35:35 CST