Re: VAT rate or VAT amount as a column?

A view isn't the same as a base table though is it? Materialised or not.

"Kenneth Downs" <knode.wants.this@xxxxxxxxxxxx> wrote in message
news:q0heq3-ghe.ln1@xxxxxxxxxxxxxxxxxxxxx
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)


.

Relevant Pages

  • 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, ...
    (comp.databases.theory)
  • Re: Rule or check
    ... Seems like a derived column (computed column) should do: ... cust INT NOT NULL PRIMARY KEY, ...
    (microsoft.public.sqlserver.programming)
  • Re: VAT rate or VAT amount as a column?
    ... In answer to your original question I suggested a trigger. ... I thought a table with a derived column in it ISN'T normalised. ... materialized columns. ... Kenneth Downs ...
    (comp.databases.theory)