Re: Separate PK in Jxn Tbl?
Date: Mon, 28 Jan 2008 14:30:09 -0000
Message-ID: <Mt2dnd8_2Y5tewDanZ2dneKdnZydnZ2d_at_pipex.net>
"David Cressey" <cressey73_at_verizon.net> wrote in message
news:%9lnj.5893$cm6.4751_at_trndny05...
>
> When it is managed by other people, it is subject to mismanagement.
> Changing values that ought to be immutable is one of many ways that
> natural
> keys can be mismanaged.
>
> As I said before, I prefer to use natural keys where ever possible. If
> that's not possible due to mismanagement of the natural keys, I'll use
> synthetic keys.
I think you may be asking too much of a natural key. I always took "stable" to mean *almost* never changes ratherer than meaning absolutely immutable (which I take to mean "intrinsically incapable of changing"). But whatever one thinks it should mean, one always has to accommodate the possibility that a key value will be mis-typed during manual entry by a user, and therefore that it will have to be corrected. Mismanagement is, as you rightly say, a fact of life.
Roy Received on Mon Jan 28 2008 - 15:30:09 CET