Re: 2nd Normal Form Question

gamehack wrote:

> Hi all,
>
> I'm currently evaluating whether a relation is in 2NF. The relation is
> defined as follows:
> <Year | Winner Name | Winner Votes | Party | Home State> in the
> context of an election. I've given a sample relation below.
> 1946 | MyName | 453 | MyParty | California
> The primary key for this relation is 'Year'.
>
> Now the question is whether this relation is in 2NF? What confuses me
> is that some books say the following:
> "Note that when a 1NF table has no composite candidate keys (candidate
> keys consisting of more than one attribute), the table is
> automatically in 2NF."

I am not sure where you read that. It sounds like a typo or a mistake. Composite keys are important at the higher normal forms. Received on Fri Feb 08 2008 - 17:39:58 CET