Re: Newbie question about db normalization theory: redundant keys OK?
From: Jon Heggland <jon.heggland_at_ntnu.no>
Date: Thu, 20 Dec 2007 12:17:52 +0100
Message-ID: <fkdj18$pq5$1_at_kuling.itea.ntnu.no>
Date: Thu, 20 Dec 2007 12:17:52 +0100
Message-ID: <fkdj18$pq5$1_at_kuling.itea.ntnu.no>
Quoth David Cressey:
> 2NF applies only to compound keys. A table that is in 1NF and has only a
> simple key is in 2NF necessarily.
Not strictly true, but the cases where such a table is not in 2NF are rare and easily detected.
-- JonReceived on Thu Dec 20 2007 - 12:17:52 CET