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: Use of numeric pseudo-key vs. text key

Re: Use of numeric pseudo-key vs. text key

From: Heinz Huber <Heinz.Huber_at_elbanet.co.at>
Date: Mon, 02 Apr 2001 09:02:01 +0200
Message-ID: <3AC823E9.FE15CAC9@elbanet.co.at>

Srinivas Venigalla wrote:
>
> There is a plenty of discussion in this group on this topic. you may want to
> search using a good search engine like google. But here is my two cents
> worth:
>
> A primary key must be part of the data the table is representing. Good
> examples of a Primary key are: Emp_ID, Product_ID, SS_NO, tel_no, etc. They
> are naturally unique keys within the enterprise or the domain.
[snip]

Beware of the pitfalls of those "naturally unique" keys. Some of them tend to be not unique! E.g. the SS_NO you mentioned: The authorities succeed in assigning the SAME SS_NO to different individuals every now and then. And then you're really screwed if you've designed your database with the SS_NO as PK.

Regards,
Heinz Received on Mon Apr 02 2001 - 02:02:01 CDT

Original text of this message

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