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
Received on Thu Jul 21 2005 - 11:41:50 CDT
