Assignment

Write a 2-3 page paper to address the issues below.

"DBMS and Datawarehousing -- II"

You are working in the data warehouse project team, and the data warehouse project is in the design phase.

1. Explain to your fellow designers how you would use a star schema in the design.

2. Explain the use of facts, dimensions, and attributes in the star schema.

3. Explain multidimensional cubes and describe how the slice and dice technique fits into this model.

4. In the star schema context, what are attribute hierarchies and aggregation levels and what is their purpose?