Re: 2NF There are two Definitions which is right

In article <3k7t18Ft6e3bU1_at_individual.net>, jens_at_haase.to says...
> I found two definitions for 2NF:
>
> 1: A relation R(A,F) is in 2NF, when every attribute not belonging to
> the primary key of R is fully functionally dependent on the primary key of R
>
> 2: A relation schema R is in 2NF if every nonprime attribute A in R is
> fully functionally dependent on the primary key of R
[8<]
> Which definition is right?

The second. Normalisation theory doesn't deal with the arbitrary primary key distinction. The first definition probably makes the assumption that there is only one key.

-- 
Jon