Re: How long is long enough for primary key ?

> "Second normal form (2NF) requires that data stored in a table with a
> composite primary key must not be dependent on only part of the table's
> primary key"
>

That doesn't mean relations can't have composite candidate keys (or primary keys) it just means that if it does have a composite key then all attributes must be dependent on the *whole* composite key, and not just part of it. Received on Sun Oct 08 2006 - 05:16:55 CDT