Re: Normalization and Derived Information

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 - 21:51:59 CEST