Re: Second Normal Form help.

Tom

I apologise for my rather curt comment ( which I also managed to post in the wrong part of the thread, where some people have gone wandering off topic)

I should have explained why you were wrong, as Kristian and Jan did (much better than I could have :=).

Peter Franklin

On Fri, 30 Mar 2001 09:14:32 -0500, "Tom" <Tom_at_webartisan.com> wrote:

>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?
>
>
Received on Fri Mar 30 2001 - 18:11:58 CEST