Re: VAT rate or VAT amount as a column?
From: Kenneth Downs <knode.wants.this_at_see.sigblock>
Date: Sun, 06 Aug 2006 11:41:16 -0400
Message-Id: <c6fhq3-r32.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)
Date: Sun, 06 Aug 2006 11:41:16 -0400
Message-Id: <c6fhq3-r32.ln1_at_pluto.downsfam.net>
> 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)
-- Kenneth Downs Secure Data Software, Inc. (Ken)nneth_at_(Sec)ure(Dat)a(.com)Received on Sun Aug 06 2006 - 17:41:16 CEST