Q3

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).