please answer all the questions 11.2a, 11.2b, 11.3 c, 11.2d. 11.3a, 11.3b, 11.3c, 11.3d. I am uploading this third time and only 11.2a question is answered for the last two chances. I need the answers as soon as possible. Thank you.

11.2 Let the following relations represent a fact table, Orders, and associated dimen- sion tables Customers, Salespeople, and Products. Orders custId prodId sales PersonId Quantity 101 1 10 20 101 2 11 8 101 3 10 15 102 1 11 10 102 2 10 12 102 3 10 15 103 1 11 9 10 40 brary/view/databases-illuminated-3rd/9781... bases 154 103 103 103 custId 101 102 103 prodId name: 1 2 3 name Adams 10 Burke 12 Collins creditRating 11. Data Warehouses and Data Mining 11 10 10 15 Price Customers Products 9 40 12 prodId 2 name Widget 3 Bolt 1 3 Drill 10 salesPersonId lastName 10 Yates 11 Zorn Price Products Salespeople W firstName Tom Zorn Steve 10 Yates Tom 11 Zorn Zorn Steve a. Draw a star schema for this data. b. Draw a data cube similar to the one shown in Figure 11.5, showing the quantity of orders placed by customers for products through salesperson 10 as the visible face. Let Customer be the x-axis and Product be the y-axis on this face. Salespeople should be the z-axis for the third dimension. If no order has been placed by a customer for a product through salesperson 10, place a 0 in the cell. c. Pivot the cube to show orders placed by customers and salesperson, with product as the third dimension. The visible face should be for product 1. d. Pivot the cube to show orders placed by salesperson and product. The visible face should be for customer 101. Add totals to make this a cross tabulation. 11.3 a. For the data cube for Exercise 11.2(b), show the roll-up on salesperson. 11.3 a. For the data cube for Exercise 11.2(b), show the roll-up on salesperson. b. Assume there are two types of widgets, bolts, and drills-small and large. Show a drill-down on product for the data cube in Exercise 11.2(b). c. For the data cube for Exercise 11.2(b). show the slice that corresponds to the se- lection WHERE salesPersonId = 2. d. For the slice in Exercise 11.3(c) dice for the range prodid