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>
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
