Re: VAT rate or VAT amount as a column?
From: Emily Jones <emilyj_at_hotmail.com>
Date: Sun, 6 Aug 2006 08:04:53 +0100
Message-ID: <44d59499$0$641$5a6aecb4_at_news.aaisp.net.uk>
Date: Sun, 6 Aug 2006 08:04:53 +0100
Message-ID: <44d59499$0$641$5a6aecb4_at_news.aaisp.net.uk>
A view isn't the same as a base table though is it? Materialised or not.
"Kenneth Downs" <knode.wants.this_at_see.sigblock> wrote in message
news: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 Sun Aug 06 2006 - 09:04:53 CEST