Q1:

The CEO of AdventureWorks Inc. wants to build a data mart to keep track of product production

inventory. He is concerned with how effective each product vendor provides the company appropriate

products. To measure the effectiveness of each product vendor, he wants to use total numbers of work

order quantity and total number of work order scrapped quantity. 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).