When large volumes of information are created daily, a companyneeds a sound infrastructure and systems in place that are capableof storing and analyzing the massive amounts of data. A datawarehouse becomes increasingly critical to this kind of business asthe scope and customer base expand.
A star schema is a type of data warehouse design that optimizesmultidimensional query performance (Poolet, 2007). The first stepin designing an information system is to construct a data model.The data model you use is a star schema.
Assignment:
Design a star schema to organize the sales information to meetthe marketing department’s needs. Identify the grain, thedimensions, the attributes of
OR
OR