please it is urgent!

Answer a,b,c,d

thank you

Please answer b , c, d

ProductName Product Type Supplier ID Depotzip Depotid ProductID PRODUCT + Supplies + SUPPLIER Co DEPOT Supplier Name Depot Size Quantity ShipsFrom Includes D OCName OCID Customer CustomerName & & 04 ORDERCLERK 1 Processes ORDER PO Submits Opo CUSTOMER Order ID covering Order Time Customer Zip (Customer Type Order Date PRODUCT ProductID Produc: Name Product Type Supplier ID (F) SUPPLIER Supplier ID SupplierName DEPOT DepotID Depot Size Depotzip ORDEREDVIA ProductID (FK) OrderID (FK1 Quantity ORDERCLERK OCID OCName ORDER OrderID Order Date Order Time CustomeriD (FK) DepotID (FK) OCID (K) CUSTOMER CustomerID CustomerName Custortier Type Customer Zip Depotzip DEPOT Depotld DepolSize D1 Small D2 Large D3 Large SUPPLIER Suppliers Supplier Name ST Super Tires | BE Batteries Etc PRODUCT ProductID Product Name Product Type SupplierID P1 Big Gripper Tire ST P2 Traction Wiz Tire ST SureStart Battery BE 60611 60660 60611 ORDERCLERK OCID OCNome OC1 Antonio OC2 Wesley OC3 Lilly ORDER OrderId Customer DepotDOCID Order Date OrderTime 01 C1 D1 OC1 1-Jan-2013 0:00:00 AM 02 C2 D1 OC22-Jan-2013 0:00:00 AM 03 C3 D2 OC3 2-Jan-2013 0:30:00 AM 04 C1 D2 OCI 3-Jan-2013 9:00:00 AM 05 C2 D3 OC2 3-Jan-2013 9:15:00 AM - 06 CS D3 OC3-Jan-2013 0:30:00 AM ORDEREDVIA ProductID Order D Quantity ! 01 4 P2 01 B P1 02 12 P2 03 4 4 PS 04 2 7 05 5 P2 06 8 PI 06 4 588 CUSTOMER Customer CustomerName Customer Type Customer Zip Aute Doc Repair Shop 60137 Bo's Car Repair Repair Shop 60140 Auto Parts Retailer 5 Question 3. Data warehouse modeling (50 points) Consider the following scenario involving Company A, an automotive products wholesaler. Company A wants to create a data warehouse to analyze its order quantities. Its Orders Database is shown in enclosed Figure. (Note: in the ERD, please replace Includes by Ordered Via). The data warehouse must enable the analysis of order quantities by: Date: including full date, day of week, day of month, month, quarter, year Time Products including product ID, product name, product type, product supplier name Customers including customer ID, customer name, customer type, customer zip Depot: including depot ID, depot size, depot zip Order Clerk: including order clerk ID, order clerk name e a) Based on the Orders Database and requirements listed above, create a dimensional model for the data warehouse. Use ERDPlus to draw the model (15 points) b) Using sample data from the Orders Database, manually populate (no SQL) the tables of the data warehouse created in a). (15 points) c) Create a dimensional model containing an aggregated fact table, where a fact table shows a summary of daily total quality for each customer. Use ERDPlus to draw the model. (10 points) d) Using the results from b), manually populate (no SQL) this aggregated fact table. (10 points) Please submit a Word file