Re: Newbie question about db normalization theory: redundant keys OK?

From: David Portas <>
Date: Thu, 27 Dec 2007 16:35:36 -0000
Message-ID: <>

"Brian Selzer" <> wrote in message news:j9Ocj.1147$
>>> Here is the problem with treating assignment as the only primitive
>>> operation. With assignment, all you have available is the before and
>>> after images of the data, but there may be many different
>>> transformations that could have produced the after image from the before
>>> image, and there's no way to tell which transformation actually
>>> occurred.
>> Yes there is.
> I suspect you would have a difficult time proving that.

I think I would have no difficulty at all. If you can show a single example where any such information is preserved after an update then I can show you the equivalent assignment to preserve the same information. It ought to be self-evident that such an assignment always exists.

David Portas
Received on Thu Dec 27 2007 - 17:35:36 CET

Original text of this message