0
5.7kviews
A manufacturing company has a huge sales network. To control the sales, it is divided into regions. Each region has multiple zones.

Each zone has different cities. Each sales person is allocated different cities. The objective is to track sales figure at different granularity levels of region and to count no. of products sold. Design a star schema by considering granularity levels for region, sales person and time. Convert the star schema to snowflake schema.

2 Answers
1
907views

enter image description here

Please log in to add an answer.