On Aug 20, 8:02 am, wrote:
you have to make the distinction between (a) the storage
of
data, and (b) the use of that data. Pure storage requires
normalisation. Use
of the data requires whatever form is necessary to convert that data
into
information or knowlege.
....

Also, the OUPUT does not guide my data model ...

I think I see what you are getting at. A report is output, hence
doesn't need to be normalized. A stored procedure's resultset is
output, hence doesn't need to be normalized. However, a SQL VIEW is a
table and tables should be normalized.

Jamie.

--