From below information build a data warehouse consisted of two data marts. Your database should meet these requirements:

$-$ DimDate table has DateKey values ranging from $20100304$ to $20140602$

$($YYYYMMDD integer data type$).$

$-$ DimDate table should have WeekNumber $($int data type$),$ IsDayLightSavingChangeToday

$($boolean data type$),$ and EnglishDayName $($varchar data type$)$ attributes

$-$ DimQuarter table should have NumberOfWeekinQuarter $($int data type$)$ attributes

$-$ DimProduct should contain ProductVendorName $($varchar data type$),$ and IsDiscontinued $($Boolean data type$)$

$-$ SCD Type $2$ for DimProduct table

$-$ One QuarterlyFactTable has $2$ foreign keys $$ ProductKey and QuarterKey, and one fact measure

$-$ QuarterlyTotalProductNeverPurchased

$-$ One FactTable has $2$ foreign keys $$ ProductKey and QuarterKey, and two fact measures $$

TotalProductPurchaseOrdered and TotalProductPurchaseSubTotal

provide a detailed explationation to all steps used in building an ETL for the above scenario.