Re: 2nd Normal Form Question

On Feb 8, 4:39 pm, Jan Hidders <hidd..._at_gmail.com> wrote:
> On 8 feb, 17:21, gamehack <gameh..._at_gmail.com> wrote:
>
> [snip]
>
> > But as we can see two non-prime
> > attributes (party & home state) are functionally dependent only a
> > subset of the primary key (the subset being the empty set). This must
> > imply that it is not in 2NF.
>
> They are not dependent on the empty set, but on the set {"Winner
> Name"}, which is clearly not a proper subset of a candidate key. So no
> 2NF violation there.
>

But isn't it a requirement for 2NF that all non-prime attribs (party & home state) _have to be_ dependent on the whole of a candidate key (as we only have 1 candidate key here which is the primary key) which is not the case in this relation. Am I wrong?

> -- Jan Hidders

Thanks,
g Received on Fri Feb 08 2008 - 17:55:38 CET