Data Warehousing for Business Applications Project Granularity and Additivity This assignment is based on having completed the hands-on exercise for this topic and the answers here use the results from that exercise. The questions in the exercise are straightforward find project budgets, total payroll, and hourly rates for employees. However, getting to the answers can illustrate the significance of granularity and measure additivity in dimensional design and the consequences it can have for end-users rely on the correctness of their data. With that, the questions for the assignment are as follows. 1. What is the total budget for each project? was the first of the three questions in the exercise. For your answer: a) Provide a screenshot of your pivot table results b) Are these results correct? If they are, thats all you have to say. If the results are not correct, first point to where they are incorrect. More importantly, state what the correct results should be and then describe any flaws or problems in the design of the star schema that are the root cause(s) of the incorrect results. If design issues are not related to the root cause of the incorrect results, state that. 2. Is payroll within budget? was the next question in the exercise, and for your answer: a) Provide a screenshot of your pivot table results b) Are these results correct? If they are, thats all you have to say. If the results are not correct, first point to where they are incorrect. More importantly, state what the correct results should be and then describe any flaws or problems in the design of the star schema that are the root cause(s) of the incorrect results. If design issues are not related to the root cause of the incorrect results, state that. 2 3. What is the average hourly pay for each employee? is the last question of the three, and as before: a) Provide a screenshot of your pivot table results b) Are these results correct? If they are, thats all you have to say. If the results are not correct, first point to where they are incorrect. More importantly, state what the correct results should be and then describe any flaws or problems in the design of the star schema that are the root cause(s) of the incorrect results. If design issues are not related to the root cause of the incorrect results, state that. 4. The fact table in the star schema you used in the exercise is shown here. After going the readings, the exercise, and answering the questions here, you may have identified some design issues as root causes of incorrect results. Based on what youve identified, think of how the design of the fact table should be changed what should be changed, what should be added, should any measures and/or dimensions should be removed or added? Then change the design of the fact table in SQL Server. For that youll need to create a new table, add the columns in your revised design, and save the table. Then for your deliverable, include: a) A screenshot of your re-designed fact table and b) A list of the items you changed, added, or removed and the reasons for each. The deliverable for this assignment is a single pdf file uploaded to Blackboard. After you have the answers completed and written in your document, save it as a pdf file, upload that file to Blackboard, and you are set