Re: Natural keys vs Aritficial Keys
From: paul c <toledobythesea_at_oohay.ac>
Date: Fri, 03 Jul 2009 02:53:27 GMT
Message-ID: <Hoe3m.33106$Db2.15258_at_edtnps83>
>> On Jul 2, 11:24 am, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
>>
>>>> Isn't any key that partially relies on a date/time field thereby
>>>> partially artificial?
>>>
>>> All keys are equally artificial. They are after all artifices for
>>> identifying things. Your own name is an artifice chosen by your parents
>>> and to which you were conditioned to respond. Unless your name is George
>>> Foreman or Prince Michael, it was chosen to be somewhat unique for your
>>> parents' ease of reference.
>>
>> If all keys are equally artificial, is a natural key then artificial?
>
> Of course. Natural keys are just familiar surrogates.
Date: Fri, 03 Jul 2009 02:53:27 GMT
Message-ID: <Hoe3m.33106$Db2.15258_at_edtnps83>
Bob Badour wrote:
> lawpoop wrote: >
>> On Jul 2, 11:24 am, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
>>
>>>> Isn't any key that partially relies on a date/time field thereby
>>>> partially artificial?
>>>
>>> All keys are equally artificial. They are after all artifices for
>>> identifying things. Your own name is an artifice chosen by your parents
>>> and to which you were conditioned to respond. Unless your name is George
>>> Foreman or Prince Michael, it was chosen to be somewhat unique for your
>>> parents' ease of reference.
>>
>> If all keys are equally artificial, is a natural key then artificial?
>
> Of course. Natural keys are just familiar surrogates.
Just a reminder - light-green keys and dark-green keys are both green! Received on Fri Jul 03 2009 - 04:53:27 CEST