Re: Normalization and Derived Information

Christopher Browne <cbbrowne_at_acm.org> wrote:

>The world rejoiced as Gene Wirchenko <genew_at_mail.ocis.net> wrote:
>> "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
>
>That might require a join against a table with prices, maybehaps...

     ...which is othogonal to whether quantity*price can be summed.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

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