Re: Normalization and Derived Information

From: Alfredo Novoa <anovoa_at_ncs.es>
Date: Wed, 22 Sep 2004 21:51:59 +0200
Message-ID: <hll3l0d7nnalckmqmnj2c3r6suimm9t5km@4ax.com>

On Wed, 22 Sep 2004 11:53:38 -0400, Kenneth Downs <firstinit.lastname_at_lastnameplusfam.net> wrote:

>Order # Qty Item Price
>========= ==== ======== =========
>1000-23 5 XJ7 75000
>1000-23 5 ES300 42500
>1001-95 1 BUGWHIP 2
>1001-95 3 FEEDBUCK 10
>
>That out of the way, now I add the column "Extended Price", a derived
>quantity that is calculated as Item * Price.

There is no problem with normalization nor redundancy if you use a view or a calculated attribute.

Regards Received on Wed Sep 22 2004 - 14:51:59 CDT