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

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 - 11:39:27 CDT