Develop a multidimensional model to analyze sales of 75,000 products over 5 years in 300 stores reporting daily sales for each type of promotion.
The following statement applies to snow flaked schemas: Large savings in storage space Normalized structures are more difficult to update and maintain Schema is…