The CEO of AdventureWorks Inc. wants to build a data mart to keep track of sales performance. He

wants to know $1)$ how many products we sell to customer and $2)$ what sales productivity of their

salesperson. Currently, the company uses total numbers of orders and sales performance ratio $($defined

by SalesYTD divided by SalesLastYear$)$ to measure the business process. Provide a $4-$steps dimensional

model in the SQL comment section $(1$ points$),$ create a data mart solution in SQL for the dimension

model that you propose $(2$ points$),$ and provide SQL commands to answer the two questions above $(2$

pointsSchemas

Sales

Purchasing

Person

Production

HumanResources

dbo