Re: Natural keys vs Aritficial Keys
From: lawpoop <lawpoop_at_gmail.com>
Date: Thu, 2 Jul 2009 08:20:34 -0700 (PDT)
Message-ID: <2fcaed05-c4d5-47be-b485-7b06c7ee115d_at_f30g2000vbf.googlegroups.com>
Date: Thu, 2 Jul 2009 08:20:34 -0700 (PDT)
Message-ID: <2fcaed05-c4d5-47be-b485-7b06c7ee115d_at_f30g2000vbf.googlegroups.com>
On May 18, 1:15 pm, "Walter Mitty" <wami..._at_verizon.net> wrote:
> "paul c" <toledobythe..._at_oohay.ac> wrote in message
>
> news:0KfQl.28513$PH1.15846_at_edtnps82...
>
> > To most people, "natural" means "physical"
>
> That's not true in my experience. Most of the people I've dealt with tend
> to think a vehicle's VIN is a natural key, and a bank account's account
> number is a natural key. both of those entities are articificial to begin
> with, and therefore all their attributes are artificial. Still, your mileage
> may vary, if you've dealt with different people than I have.
Isn't any key that partially relies on a date/time field thereby partially artificial? Received on Thu Jul 02 2009 - 17:20:34 CEST