Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LearnSQL
Starting Member
12 Posts |
 Posted - 2001-08-31 : 11:20:53
|
| Hi!I have some questions.Suppose we have,CREATE TABLE dbo.MyTable(FY smallint NOT NULL,TMonth tinyint NOT NULL,CCode varchar(12) NOT NULL,RCode varchar(8) NOT NULL,Received int NULL,Sent int NULL,Comment int NULLConstraint pk_myTable Primary Key Clustered (FY, TMonth, CCode, RCode))How many primary key(s) do you see in above table? Can above table be perhaps part of 3rd Normal form?We have people disputing that DB is not normalized at all and there are multiple primary keys in number of tables!Thank you for your help! |
|
|
|
|
|
Primary Key & Normalization