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: Normalization, Natural Keys, Surrogate Keys

Re: Normalization, Natural Keys, Surrogate Keys

From: Galen Boyer <galendboyer_at_yahoo.com>
Date: 16 May 2002 22:14:07 -0500
Message-ID: <un0uz9tzv.fsf@rcn.com>


On Thu, 16 May 2002, richdillon_at_mindspring.com wrote:

> Neglecting to declare a natural key undermines your ability to protect
> the integrity of your data.

A natural unique index should suffice. Then a generated key makes for a much easier to understand and code to model, (in my opinion). Restrict on the natural fields to restrict on but join on the generated keys. To me, this just seems a whole lot easier to understand and code to, which makes for more successful projects.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Thu May 16 2002 - 22:14:07 CDT

Original text of this message

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