Q2: The CEO of AdventureWorks Inc. wants to build a data mart to keep track of the product production's lifecycle. Specifically, he wants to know the total number of products when the company received work order and bill of materials. 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).

Fig: 1