Re: Normalization and Derived Information

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...

-- 
wm(X,Y):-write(X),write('_at_'),write(Y). wm('cbbrowne','linuxfinances.info').
http://linuxfinances.info/info/rdbms.html
"In computing, invariants are ephemeral."  -- Alan Perlis