Use Adventure Work OLTP logical schema to build data warehouse tables in SQL$,$ Provide a $4-$steps dimensional model in the SQL

create a solution in SQL for the dimension model

Explain each step by giving commands

Answers two questions:

$1)$ What is

Weekly Conversion Rate of Customer $($defined by total number of customer purchase at least one

product divided by total number of all customers$)]$

$2)$ How often AdventureWorks purchase a

particular product from vendor$($s$).$