Roxanne:

As an aside, I saw an interesting book in the library regarding data warehousing and database design. Darned if I can remember the name offhand, but I was searching under "database design" when I found it. Maybe it could answer some of your questions about how things should be set up in general.