Re: Normalization and Derived Information

"Laconic2" <laconic2_at_comcast.net> wrote:

[snip]

>The advantage of the extended price is that it can be summed. (other trivia
>about star schema design omitted).

     And quantity times price can not?
          select sum(quantity*price) as extendedsum from orders

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.