Re: VAT rate or VAT amount as a column?
From: Kenneth Downs <knode.wants.this_at_see.sigblock>
Date: Sat, 05 Aug 2006 08:54:03 -0400
Message-Id: <q0heq3-ghe.ln1_at_pluto.downsfam.net>
Date: Sat, 05 Aug 2006 08:54:03 -0400
Message-Id: <q0heq3-ghe.ln1_at_pluto.downsfam.net>
Emily Jones wrote:
>
> I thought a table with a derived column in it ISN'T normalised.
> Functionaly dependent not on the Primary Key, or something. No?
>
>
Correct. But neither is the data in many views. Both are system controlled (if you go triggers) so whatever theory allows views allows the materialized columns.
-- Kenneth Downs Secure Data Software, Inc. (Ken)nneth_at_(Sec)ure(Dat)a(.com)Received on Sat Aug 05 2006 - 14:54:03 CEST