Let the following relations represent a fact table, Orders, and associated dimension tables Customers, Salespeople, and Products. Draw a star schema for this data?  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?

 

custId 101 101 101 102 102 102 103 103 prodId 1 2 3 1 2 3 1 2 Orders sales PersonId Quantity 10 11 10 11 10 10 11 10 20 8 15 10 12 15 9 40 custId 101 101 101 102 102 102 103 103 prodId 1 2 3 1 2 3 1 2 Orders sales PersonId Quantity 10 11 10 11 10 10 11 10 20 8 15 10 12 15 9 40 custId 101 101 101 102 102 102 103 103 prodId 1 2 3 1 2 3 1 2 Orders sales PersonId Quantity 10 11 10 11 10 10 11 10 20 8 15 10 12 15 9 40 custId 101 101 101 102 102 102 103 103 prodId 1 2 3 1 2 3 1 2 Orders sales PersonId Quantity 10 11 10 11 10 10 11 10 20 8 15 10 12 15 9 40