Re: Second Normal Form help.

I was wrong, james.. You'll have to forgive me, I'm pretty new at this. What I didn't remember about 2nf is that concatenated keys only cause trouble when a non-key attribute is functionally determined by one of the keys and not the key combination, so you were ok from the get-go. - my stupid mistake.

Correct me if I'm wrong guys - I know you will - but if there were an attribute in the table such as StreetAddress (that would belong in the buildings table) that was dependant on only the BuildingID, that would cause a violation, right?

> CREATE TABLE Garages (
> BuildingID int NOT NULL REFERENCES Buildings(BuildingID),
> GarageNumber int NOT NULL ,
> Width int NOT NULL ,
> Length int NOT NULL ,
> Height int NOT NULL,
> PRIMARY KEY (BuildingID, GarageNumber)
> )
Received on Fri Mar 30 2001 - 16:14:32 CEST