1. Agents change territories over time. If necessary, redesign your answer to Problem and Exercise 14 to handle this changing dimensional data. Problem and Exercise 14 Would you prefer to normalize...

1. Agents change territories over time. If necessary, redesign your answer to Problem and Exercise 14 to handle this changing dimensional data.

Problem and Exercise 14

Would you prefer to normalize (snowflake) the star schema of your answer to Problem and Exercise 13? If so, how and why? Redesign the star schema to accommodate your recommended changes.

Problem and Exercise 13

Create a star schema for this case study. How did you handle the time dimension?