Information Systems Assignment
Scenario: A retail bookstore chain has branches across the United Kingdom. The senior management has strategically decided to implement a data warehousing solution to enable better decision-making and to gain a competitive advantage over its competitors. Imagine that you have been hired by the firm as a data warehousing consultant. You need to solve the following tasks as part of your role as a consultant.
Tasks
1- Evaluate the data warehouse and DBMS solutions available in the market. Present your findings as a comparative analysis of 3-5 different solutions. Provide a summary with your selection of the best solution. Cite relevant reasons for your choice using the Harvard Liverpool Referencing System.
2- Explain how the bookstore chain could use multi-dimensional cubes as a part of its data warehousing solution. Explain how the chain could use the 'slice and dice' technique in this solution.
3- Explain how the bookstore chain could use the star schema in its data warehousing solution. Describe the performance improvement techniques that should be used for the star schema. Justify your answers to convince the bookstore chain's management team to use the star schema as part of their data warehousing solution.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.