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: Greg D. Moore \(Strider\) <mooregr_at_greenms.com>
Date: Tue, 21 May 2002 00:24:02 GMT
Message-ID: <CsgG8.84271$2G1.29527881@typhoon.nyroc.rr.com>

"Pablo Sanchez" <pablo_at_dev.null> wrote in message news:3ce97890$1_12_at_news.teranews.com...
>
> "--CELKO--" <71062.1056_at_compuserve.com> wrote in message
> news:c0d87ec0.0205201359.120ca460_at_posting.google.com...
> > >> The SSN is a surrogate key itself, and a BAD one at that. There
> are
> > duplicates out there. <<
> >
> > With Mexican illegals in Calfornia, Texas and other states,
>
> Singling out one ethnic group isn't very productive.... oh well ...
> amazing ... no, actually it's not ...
>
> Businesses operated by good old American citizens are generating
> duplicate social security numbers for illegal aliens.

It's not even that. Under the original scheme there was no method of generating unique SSN's. Since the first 3 digits were code digits, you had a smaller set of unique numbers to chose from. The original thinking was that people would die off fast enough they'd have no proble recycling numbers.

At this point I'm not aware that the SS Administration has handed out any legit dupicates and I know they've taken steps in the past decade or so to eliminate this problem.

> --
> Pablo Sanchez, High-Performance Database Engineering
> mailto:pablo_at_hpdbe.com
> http://www.hpdbe.com
> Available for short-term and long-term contracts
>
>
Received on Mon May 20 2002 - 19:24:02 CDT

Original text of this message

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