Discuss the major design issues that need to be addressed before proceeding with the data design.
Why is the entity-relationship modeling technique not suitable for the data warehouse? How is dimensional modeling different?
What is the STAR schema? What are the component tables?
A dimension table is wide; the fact table is deep. Explain.
What are hierarchies and categories as applicable to a dimension table?
Differentiate between fully additive and semiadditive measures.
Expla in the sparse nature of the data in the fact table.
Describe the composition of the primary keys for the dimension and fact tables.
Discuss data granularity in a data warehouse.
Name any three advantages of the STAR schema. Can you think of any disadvantages of the STAR schema?