Re: Normalization, Natural Keys, Surrogate Keys

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