Design the star schema for the application.

2.1kviews

(Duplicate) Design the star schema for the application.

written 6.9 years ago by

aartisahitya • 160

modified 2.6 years ago by

sagarkolekar ★ 11k

For a super market chain, consider the following dimensions namely product, store, time and promotion. The schema contains a central fact table for sales.

i) Design the star schema for the above application.

ii) Calculate the maximum number of base fact table records for warehouse with the following values given below:

Time periods - 5 years
Store - 300 stores reporting daily sales
product - 40,000 products in each store (about 4000 sell in each store daily)

data warehouse and mining

ADD COMMENT EDIT

Marked as duplicate
This question already has an answer, hence merged with: Consider following dimensions for a Hypermarket chain: Product, Store, Time and Promotion. With respect to this business scenario, answer the following questions,

2.6 years ago by binitamayekar ★ 6.6k