Re: 3NF question

From: <tore.trollsaas_>
Date: Mon, 10 Jan 2005 22:33:38 +0100
Message-ID: <j2t5u05bth05ifgms9olapikovve4n2tfm_at_4ax.com>


On 9 Jan 2005 16:07:46 -0800, "jonnie" <jsavell_at_gmail.com> wrote:

>
>DA Morgan wrote:
>
>> > I respect what you have said. On the otherhand, I would like to say
>> > that I believe ID can be an acceptable attribute for an object,
>even if
>> > a sequential identity scheme is deemed unsuitable.
>>
>> I disagree. A person table might have a person_id that uniquely
>> identifies that person within a specific application. But a column
>named
>> ID has no place in any set.
>
>OK. If that's all I have to do to get off the fire, then fine. I would
>like it to be called person_id instead of ID.
>
>-jonnie

... and possibly you would even consider MemberNbr, EmployeeNbr , SSN, etc. Maybe even ZipCode ;-)

Consider what would happen if they were all named ID ? "ID What?"

mvh Tore Received on Mon Jan 10 2005 - 22:33:38 CET

Original text of this message