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: Bernard Peek <bap_at_shrdlu.com>
Date: Tue, 28 May 2002 17:17:20 +0100
Message-ID: <7kNhxnwQ2688EwNF@shrdlu.com>


In message <c1ec9b8f.0205241023.ebb99a0_at_posting.google.com>, Kai Ponte <cybermusicdude_at_aol.com> writes

>> Having a surrogate primary key shouldn't let you off the hook. As a
>> rule of thumb, you always HAVE TO HAVE an alternate UNIQUE constraint.
>I respectfully disagree with "always have to have." Yes, it may often
>be necessary, but not always.

Can you suggest a situation where you do not need a unique constraint in addition to the surrogate?

-- 
Bernard Peek
bap_at_shrdlu.com

In search of cognoscenti
Received on Tue May 28 2002 - 11:17:20 CDT

Original text of this message

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