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?

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

To create a star schema for this data we can follow these steps 1 Identify the fact table which is t... View the full answer