Use Adventure Work OLTP's Production and Purchasing schema to build a data warehouse consisted of two data marts. (You can find instructions to install the database in Topic 2 if you haven't installed yet). (70 points). Your database should meet these requirements: - DimDate table has DateKey values ranging from 20100304 to 20140602 ( YYYYMDD integer data type). If you use Flat File or Excel Data Source to import date key data, include the data source file in the submission also (5 points). DimDate table should have IsMemorialDay (BOOLEAN data type), WeekNumberOfYear (INT data type), NumberOfDayUntilEndOfYear (INT data type), and Quarter (INT data type) attributes (15 points). - DimProduct should contain product ID, product name, category name, product vendor name, and Current Value (10 points). Dim Product should be able to handle Type 2 SCD issues ( 5 points). - FactlessProductSellingTable has 2 foreign keys - SellStartDateKey and ProductKey (10 points). - PurchasingPerformance has 2 foreign keys - PurchaseOrderDateKey and ProductKey (10 points). - Correct ETL process to create 3 fact measures for PurchasingPerformance (15 points) The following table and graph show you the data description of fact measures and ERD of the data warehouse