1-Classify the major issues associated with designing a data warehouse database. 2-Discuss the activities associated with each...
Question:
1-Classify the major issues associated with designing a data warehouse database.
2-Discuss the activities associated with each of four primary data flows or processes within a data warehouse.
3-What does Online Analytical Processing (OLAP) represents.
4-Discuss how OLAP functionality is provided by the ROLLUP and CUBE functions of the sql standard
5- As a database analyst, you were asked to design a database for maintaining data for a university. A university system is software that uses to maintain the record of the university. It contains collages and departments, the departments offer courses every semester, each department employ professors to teach these courses, and the students register several courses each semester. Apply the normalization techniques and identify how many tables you need in your database, show both database and table schema. (4 marks)
[Rubric: 4 marks for correct and complete solution, 3 marks for partially correct and incomplete solution, 2 marks if major points are missing and incomplete, 1 marks if some points are correct, and 0 mark for incorrect and incomplete solution.]
2. Since OLAP servers are based on multidimensional view of data, suggest the OLAP operations that you will use for multidimensional data of the Organization Medical Equipment's Inc. Explain one operation in details.
[Rubrics: 2 marks for all the operations, 2 marks for the complete explanation]
3. Compare the logical design and physical design for a database required for a company named “Rental Properties” which deals with renting and selling Flats/villas. Assume data suitably.
[Rubrics: 1 mark for each comparison]
III. ANALYSIS: Answer the following questions: [2 questions: 2x 5 marks = 10 Marks]
1. You are asked by the Managing Director of DreamLand Inc. (sales and purchases of villa and flat) to investigate and report on the applicability of data warehousing for the organization. The report should compare data warehouse technology with OLTP systems and should identify the advantages and disadvantages, and any problem areas associated with implementing a data warehouse. (5 marks)
[Rubrics: 2 marks for comparison, 2 marks for advantages and disadvantages, 1 marks for the problem areas]
2. In large data warehouse environments, many different types of analysis can occur as part of building a platform to support business intelligence. In addition to traditional SQL queries, user requires to perform more advanced analytical operations on the data. Suggest two operations to the user with valid and convincing reasons. (5 marks)
Cost Management Accounting and Control
ISBN: 978-0324559675
6th Edition
Authors: Don R. Hansen, Maryanne M. Mowen, Liming Guan