and 4 others joined a min ago.
0
1.8kviews
(Duplicate) Design the star schema for the application.
written 6.3 years ago by
aartisahitya
• 160
|
modified 2.1 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)
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,