Re: the relational model of data objects *and* program objects

From: Alfredo Novoa <alfredo_novoa_at_hotmail.com>
Date: Wed, 13 Apr 2005 18:39:27 +0200
Message-ID: <joiq51d0uv4pban9oaq0n9lh05n2hi3k65_at_4ax.com>


On 13 Apr 2005 07:16:53 -0700, "erk" <eric.kaun_at_gmail.com> wrote:

>> A column like extended=price*qty violates 3rd normal form and "does
>not
>> belong", hence my comment later in my post that pure database
>theorists
>> will throw away data to preserve a theory.
>
>"Extended" isn't data. It's a function, or calculation.

It is data, but derived data. A table view a calculated column is a view and not a base table.

Regards Received on Wed Apr 13 2005 - 18:39:27 CEST

Original text of this message