Re: VAT rate or VAT amount as a column?

From: Kenneth Downs <knode.wants.this@xxxxxxxxxxxx>
Date: Sat, 05 Aug 2006 08:54:03 -0400

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)
.

Follow-Ups:
- Re: VAT rate or VAT amount as a column?
  - From: Emily Jones

References:
- VAT rate or VAT amount as a column?
  - From: Emily Jones
- Re: VAT rate or VAT amount as a column?
  - From: Emily Jones

Prev by Date: Re: No more dbs about SOCIAL NETWORKS
Next by Date: Re: computational model of transactions
Previous by thread: Re: VAT rate or VAT amount as a column?
Next by thread: Re: VAT rate or VAT amount as a column?
Index(es):
- Date
- Thread

Relevant Pages

Re: VAT rate or VAT amount as a column?
... I thought a table with a derived column in it ISN'T normalised. ... Functionaly dependent not on the Primary Key, ... (if you go triggers) ... Kenneth Downs ...
(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)