Assignment: Data Mart/Data Warehouse Access
Diagram out a data warehouse including all of the information that would be needed for it to be a premier Decision Support System. Choose an industry and a fictional company in that industry as the basis for your data warehouse. Keep in mind the ideas we've covered so far: The data will need to enter the system, will need to be transformed into the long-term storage format, and will need to be stored long term. What will it look like? How big will it be? How will it be advantageous to the company?
Secondly, consider three different actors within the company, with three different user roles. In order to perform their duties, what sort of a data mart would need to be set up for them? Consider time, location, and security issues, as well as any others that you can think of or research in your answer.
Remember to support your responses with research (including adequate references), and to respond politely to your classmates.
Submit your assignment via this assignment's link as a Word .doc file, it should be approximately 3 pages in length with several academic references to support your position. Please feel free to discuss this in the discussion board. I'm happy for the class to come to a consensus opinion (as long as you submit your own paper with your own researched references).