Re: Trying to define Surrogates

From: David Cressey <dcressey_at_verizon.net>
Date: Thu, 17 Aug 2006 20:50:54 GMT
Message-ID: <OE4Fg.896$1T5.104@trndny05>

"erk" <eric.kaun_at_gmail.com> wrote in message news:1155829018.817708.300210_at_p79g2000cwp.googlegroups.com...
> case. I think the more common use of a surrogate key is where no
> natural key exists - to separate cans of Campbell's chicken noodle
> soup, you need to give them an artificial label. This label sometimes
> makes it into the real world as well.

Off topic. The above case is known as "the cat food problem", but Campbell's chicken noodle works just as well.

PS: we're getting dangerously close to an issue Dawn raised in about the 2002, 2003 time frame. She'll have no compuctions at all about raising it again, and then blaming her middle aged memory if anybody calls her on it. Received on Thu Aug 17 2006 - 15:50:54 CDT