Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Newbie question about db normalization theory: redundant keys OK?

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@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.

-- 
Jon


Received on Thu Dec 20 2007 - 05:17:52 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US