Re: Newbie question about db normalization theory: redundant keys OK?
From: Tony Rogerson <tonyrogerson_at_torver.net>
Date: Sun, 16 Dec 2007 22:06:15 -0000
Message-ID: <fk47j4$7oc$1$830fa79d_at_news.demon.co.uk>
Date: Sun, 16 Dec 2007 22:06:15 -0000
Message-ID: <fk47j4$7oc$1$830fa79d_at_news.demon.co.uk>
David,
Stop trying to divert; you got it wrong; just leave it there.
Here is the original ddl...
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));
-- Tony Rogerson, SQL Server MVP http://sqlblogcasts.com/blogs/tonyrogersonReceived on Sun Dec 16 2007 - 23:06:15 CET
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]