Re: VAT rate or VAT amount as a column?

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@(Sec)ure(Dat)a(.com)