The Homeowners Insurance Company has set an objective to increase their market share by 15%. To do so, they realize they must have a better understanding of their existing customers.
Working in your team, design and document a star or snowflake schema to support this goal.
Create and submit a report that addresses the following:
Indicate the attributes within the fact and dimension tables and clearly note the primary and foreign keys.
Sample Solution