X wants to create an analytical database (data warehouse) to analyze its order quantities. X would like to be able too analyze the quantities of each product per order. The two available data sources are (1) the X Orders Database Relational Schema and (2) the X Human Resources Dept table. Both are shown below The data warehouse should support an analysis of order quantities by . Date, including full date, day of week, day of month, month, quarter, year Time (of order) Product, including product ID, product name, product type, product supplier name Customer, including customer ID, name, type, and zip . Depot, including depot ID, size and zip Order Clerk, including order clerk ID, clerk name, clerk title, clerk education level, clerk year of hire PRODUCT X Orders Database Relational Schema ProductID ProductName Productrype SupplierID (FK) SUPPLIER SupplierID SupplierNarne DEPOT DepotID DepotSize DepotZip ORDEREDVIA ProductID (FK) OrderID (FK) Quanti ORDER ORDERCLERK OCID OCName OrderID OrderDate OrderTime CustomerlD (FK) DepoID (FK) OCID (FK) CUSTOMER CustomerID CustomerName CustornerType CustornerZip X wants to create an analytical database (data warehouse) to analyze its order quantities. X would like to be able too analyze the quantities of each product per order. The two available data sources are (1) the X Orders Database Relational Schema and (2) the X Human Resources Dept table. Both are shown below The data warehouse should support an analysis of order quantities by . Date, including full date, day of week, day of month, month, quarter, year Time (of order) Product, including product ID, product name, product type, product supplier name Customer, including customer ID, name, type, and zip . Depot, including depot ID, size and zip Order Clerk, including order clerk ID, clerk name, clerk title, clerk education level, clerk year of hire PRODUCT X Orders Database Relational Schema ProductID ProductName Productrype SupplierID (FK) SUPPLIER SupplierID SupplierNarne DEPOT DepotID DepotSize DepotZip ORDEREDVIA ProductID (FK) OrderID (FK) Quanti ORDER ORDERCLERK OCID OCName OrderID OrderDate OrderTime CustomerlD (FK) DepoID (FK) OCID (FK) CUSTOMER CustomerID CustomerName CustornerType CustornerZip