Use Adventure Work OLTP logical schema to build data warehouse tables in SQL $(100$ points$).$:

Question $1$:

The CEO of AdventureWorks Inc. wants to build a data warehouse to answers two questions: $1)$ Monthly

Total Product Customer Purchased and $2)$ Quarterly Conversion Rate of Customer $($defined by total

number of customer purchase at least one product divided by total number of all customers$).$ Provide a

$4-$steps dimensional model in the SQL comment section $(10$ points$),$ create a solution in SQL for the

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

above $(10$ points$).$

Question $2$:

The CEO of AdventureWorks Inc. wants to build a data warehouse to answers two questions: $1)$ How

quickly products were moved from vendor$$s order status to vendor$$s shipping status and $2)$ how many

products were ordered and shipped from vendor. Provide a $4-$steps dimensional model in the SQL

comment section $(10$ points$),$ create a solution in SQL for the dimension model that you propose $(30$

points$),$ and provide SQL commands to answer the two questions above $(10$ points$).$