Answer Happy

Question 2 The following diagram shows a consulting services and expense analysis information package. As a manager, typically the areas of interest include the individual consultant and the associated management chain; the projects that are active as well as historical perspective of similar projects for planning purposes; and the types of expenses incurred. Categories Dimensions All Time Periods Years All Consultants Region All Expenses Expense Class All Projects Project Classes Customer Project Code Expense Category Quarters Period Ended District Office Consultant Measures/Facts: Reimbursable by Customer Amount, Internal Expense Amount 1) Construct a star schema based on the information package (10 marks) 2) Give 3 example questions that this information package can assist the user in answering (10 marks).