2NF Controversy

1. One side suggests that in order for a table to violate 2NF, the table must have attributes that are dependent on only part of a compound PK--this implies that 2NF violations only apply to situations in which a table has a compound PK. This requirement has been stated explicitly in several definitions.
2. The other side suggests that tables violate 2NF when non-key attributes apply to multiple rows. This definition also applies to tables with simple PK's.

Which defintion is correct? Or are neither correct?

RK Received on Sat May 29 2004 - 09:14:10 CDT