Tony Rogerson wrote:
>
>> ID FNAME LNAME
>> 1 Daniel Morgan
>> 2 Jack Cline
>> 3 Daniel Morgan
>>
>> That surrogate key accomplished precisely what?
>
> And where is your natural key?
The point was to demonstrate the surrogate keys are worthless
for purposes of data integrity with most data. What ends up
happening is that unique constraints are then built, on top of
the surrogate key, in an attempt to do what the surrogate can
not.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Aug 24 2007 - 12:50:01 CDT
