On 16 Aug, 19:53, "Jeff Boyce" wrote:
I'm looking for the basis.

What, that a VIEW is a logical table? Have you tried doing a google
search? e.g.

sql view virtual OR logical table
http://www.google.co.uk/search?q=sql...+logical+table

Now try the same using e.g.

normalization view virtual OR logical table
http://www.google.co.uk/search?q=nor...ogical+tab le

though you could drop the word 'virtual' from the search because
'virtual tables' are a SQL (the language) concept.

From these readings you may glean the following formal process:

1) As Mrs Beeton would say, "First, catch you your business model."
2) Design a logical model applying the rules of normalization to
create logical tables and the relationships between them.
3) Implement your logical model in SQL (or other relational
technology); the logical tables from your logical model sometimes are
directly implemented as a physical SQL base table and sometimes not.

So, in my book, my SQL implementation must be true to my logical model
and in turn my logical model must be true to normalization. If you are
looking for a reference that applies normalization to VIEWs then I
don't think you will find one because there is a stage in between --
logical model -- that cannot be disregarded. I don't see anything in
this process that offers 'normalization immunity' to virtual tables.

Jamie.

--