a. Identify the appropriate fact table components (attributes). (5 pts)

b. Identify the appropriate dimension tables and appropriate attributes for each. (5 pts)

(Deriving attributes may require some creativity)

c. Draw a star schema diagram for this data warehouse. (10 pts)

Victoria Ephanor manages a small product distribution company. Because the business is growing fast, she recognizes that it is time to manage the vast information pool to help guide the accelerating growth. Ephanor, who is familiar with spreadsheet software, currently employs a sales force of four people. She asks you to develop a data warehouse application prototype that will enable her to study sales figures by year, region, salesperson, and product. Using the data supplied in the following table, answer the following questions: Year 2016 2016 2016 2016 Region East East North North South South West East Agent Carlos Tere Carlos Carlos Victor Victor Mary Carlos Victor Mary Victor Carlos Mary Tere Carlos Tere 2016 2016 2016 2017 Product Erasers Erasers Widgets Widgets Balls Balls Pencils Pencils Balls Pencils Erasers Widgets Widgets Erasers Widgets Balls Value 50 12 120 30 145 34 56 45 2017 55 60 2017 2017 2017 2017 East North North South South South West 20 30 75 2017 90 2017 25 2017 West 100