Re: 4 the FAQ: Are Commercial DBMS Truly Relational?

From: Kenneth Downs <firstinit.lastname_at_lastnameplusfam.net>
Date: Sun, 10 Oct 2004 22:01:34 -0400
Message-ID: <uhpckc.3va.ln_at_mercury.downsfam.net>


Gene Wirchenko wrote:

> Kenneth Downs <firstinit.lastname_at_lastnameplusfam.net> wrote:
>

>>Gene Wirchenko wrote:

>
> [snip]
>
>>>      That single, unique column is also a constrained (PK).  What
>>> happens when a key for that column is entered wrong?  Why would it be
>>> any different for another key for another unique column, say SSN?

>
>>The key fact about the Employee_ID column is that by definition it has no
>>meaning, it is correct if and only if it is unique.  It's only purpose is
>>to be unique.

>
> An SSN is correct iff it is unique, too.
>

Um, no. If you are entered with my SSN it is not correct even if unique.

-- 
Kenneth Downs
Use first initial plus last name at last name plus literal "fam.net" to
email me
Received on Mon Oct 11 2004 - 04:01:34 CEST

Original text of this message