Design of fact table(s) and dimensions tables for data warehouse
The IBM Redbooks have a couple of good titles on modeling a data warehouse.


Data Modeling Techniques for Data
Warehousing
Dimensional Modeling: In a Business
Intelligence Environment


You might be better served with an OLTP database in 5NF, though. It's not hard to test simplified versions of both.