Re: Normalization, Natural Keys, Surrogate Keys
Date: 20 May 2002 14:59:15 -0700
Message-ID: <c0d87ec0.0205201359.120ca460_at_posting.google.com>
>> The SSN is a surrogate key itself, and a BAD one at that. There are
With Mexican illegals in Calfornia, Texas and other states, the
duplicates out there. <<
>> It is "just as good" as a surrogate. In fact, it might be worse,
because at least I can QA my surrogate, but I can't QA the
government's surrogate for Person. <<
Actually, there are several websites that will validate SSN for you and the US Government used to have a "Project Clean Data" where they would send you files of SSNs with the date and place of issue. You can check the data yourself and might even have gotten mailing from the Social Security Administration summarizing your account. Received on Mon May 20 2002 - 23:59:15 CEST