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.
Use the Crows Feet notation template in Visio to document your model.
Sample Solution