Star Schema 1. Compare and contrast the star schema and snowflake schema. What are the components of a star schema? Describe the relationship between dimension and fact tables. OLAP vs OLTP 2. What are some

Star Schema 1. Compare and contrast the star schema and snowflake schema. What are the components of a star schema? Describe the relationship between dimension and fact tables. OLAP vs OLTP 2. What are some differences between operational systems and data warehouses?  How is the data different?