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: Artificial Primary keys

Re: Artificial Primary keys

From: Jan Emil Larsen <jel_at_g-it.dk>
Date: Wed, 23 Jan 2002 23:51:47 +0100
Message-ID: <3c4f3e5e$0$13976$edfadb0f@dspool01.news.tele.dk>

"--CELKO--" <71062.1056_at_compuserve.com> skrev i en meddelelse news:c0d87ec0.0201231034.53f2b017_at_posting.google.com...  > ... How do you know that number 123 is
> really "John Smith" and pay salaries and taxes to him? Did you put
> him in the database twice? Did someone else get his number? Who
> knows? With SSN, which you have to have anyway, you can verify it
> with other documents and the tax boys.

In the same way as he knows that "John Smith" is "John Smith", and has this SNN, that Address etc.
He has one or more (near) candidate keys (eg SSN) with unique indices if possible and useful.
A surrogate (artificial) key doesn't rule out the use of natural candidate keys in the communication etc. with the users. I guaranties that he can handle even a person with none or unknown SSN.

A key should be imutable, and should therefore be without information in it self.
Skip the start-date as part of the key. Received on Wed Jan 23 2002 - 16:51:47 CST

Original text of this message

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