It just occurred to me. The purpose of normalizing the information and
having it stored on two separate tables is defeated if I have another
table that contains the same information but in an un-normalized
fashion. I would end up with two copies of the same information, one
normalized but not ready to be used by aggregate functions and another
un-normalized table kept up to date with triggers and ready to be used
by aggregate functions. Right? :-/
So that leaves the temporary table solution on the front end or views
on the back end. Any thoughts?