Re: Natural keys vs Aritficial Keys
Date: Mon, 18 May 2009 17:15:44 GMT
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.
Maybe the distinction between "natural" and "synthetic" would be clearer if we changed the labels. How about "external" versus "internal"? This still begs the question of whether I mean internal to the database or internal to the application and the database. But maybe it's a step in the right direction. How about "conceptual key" versus "logical key"? Received on Mon May 18 2009 - 19:15:44 CEST