Write 500 Word Summary Defines Compares Contrasts Ross Kimball Approaches Data Warehousing Q37038941

1. Write a 500-word summary that defines, compares, and contraststhe Ross and Kimball approaches to data warehousing. Please includethe characteristics of the data warehouses as output of eachapproach. Provide five references within the paper and cite atleast two within your writing. (40 points)
2. Design a star schema to organize the sales information to meetthe marketing department’s needs. Identify the grain, thedimensions, the attributes of those dimensions, the fact table, andthe attributes of the fact table. Provide an ERD or UML of thedimensional model. (60 points)

Solution