The CEO of AdventureWorks Inc. wants to build a data mart to keep track of store's monthly sales performance. Specifically, he wants to keep track of monthly tax effectiveness (defined by Tax Amount divided by Sales SubTotal) and monthly sales amount. Provide a 4-steps dimensional model in the SQL comment section (1 points) and create data mart solutions in SQL for the dimension model that you propose (3 points).

The CEO of AdventureWorks Inc. wants to build a data mart to keep track of the sale orders lifecycle. Specifically, he wants to know the total numbers of orders when they are ordered, due, and shipped to the customer. Provide a 4-steps dimensional model in the SQL comment section (1 points) and create a data mart solution in SQL for the dimension model that you propose (2 points).