Explain the technology and approach you would use to handle the needs for studying historical trends in the information you have collected, combining it with other databases if needed. What information from the database would you collect over time?
Defines the star model for the data warehouse for this information. What information will you store in the Fact table? What attributes will it have? What dimension tables will you create? How will you organize the dimension tables? How are they related to the Fact table? What physical structures (eg, specialized indexes) will you use to make the data warehouse efficient?
Explain, at a level suitable for business management, what they will be able to find out using this, both by breaking down information according to one or more dimensions, or drilling down on individual cells.
Combine these items and submit in a 1- to 2-page APA formatted paper, with the Star schema diagram contained / pasted in it.