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

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.

Mumbai University > Computer Engineering > sem 8> data warehouse and mining

Marks: 10M

mumbai university • 348 views
ADD COMMENTlink
modified 3 months ago by gravatar for RB RB ♦♦ 110 written 4 months ago by gravatar for Ankit Pandey Ankit Pandey70
0

enter image description here

ADD COMMENTlink
modified 3 months ago by gravatar for Yashbeer Yashbeer160 written 3 months ago by gravatar for Ankit Pandey Ankit Pandey70
Please log in to add an answer.