The Task:

Part 1. Design a star schema that meets the needs of both requirements based on the ERD embedded.

Using PowerPoint, Word or NotePad, provide the design of the star schema and return it with the code written below.

Part 2. Write a MS SQL-server stored procedures that produces a data set based on the star schema you have designed.

Part 2 a: Write the stored procedure to extract data from your star schema for the machine learning algorithm. You should include the columns:

ProductID

Order Quantity

SalesorderID

Sales Person Firstname

Sales Person Lastname

Order Date

TerritoryID

Part 2b: Write the stored procedure to extract data from your star schema for the Management Report. The procedure should accept the following parameters: Territory and a group of sales people (one or more). You should include the following columns:

TerritoryID

Job Title

Sales Person FirstName

Sales Person LastName

Sales YTD