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: identity columns

Re: identity columns

From: Ben Clifford <benc_at_hawaga.org.uk>
Date: Thu, 03 Jan 2002 18:29:33 GMT
Message-ID: <3C34A30B.317DCC5B@hawaga.org.uk>


Russ News wrote:

> They use first initial + middle initial + last initial +
> the last four digits of SSN to uniquely identify it's employees. Once its
> assigned, it doesn't change even with a name change.

There are user-interface problems with:

> Once its assigned, it doesn't change even with a name change.

People get upset that their unique ID still has their old name in it, especially non-technical folk.

Although, I have seen systems (a US gov't system) where the unique ID appeared to be a combination of SSN and name - and *changed* when the students name was changed. This is even worse!

-- 
Ben Clifford     benc_at_hawaga.org.uk
http://www.hawaga.org.uk/ben/  GPG: 30F06950
webcam: http://barbarella.hawaga.org.uk/benc-cgi/watchers.cgi
Work required: http://www.hawaga.org.uk/~benc/resume
Received on Thu Jan 03 2002 - 12:29:33 CST

Original text of this message

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