Solve question E8.3b

Answer for 8.3a

270 Part 2 Analytical Databases peoduct type ER.2b Cmate a dimensional model containing an aggre- gated fact table, where a fact table shows a sum- * product supplier name * customer ID e customer type , customet, including mary of daily nevenue amount for each officer ESc Populate the tables created in EX.2b with the data Use the data that you used to populate the tables in the Figure 8.46 as a bhasis for agogregation. customer zip depot, including ES3 Consider the following scenario involving Big Z Inc, an depot ID e depot size wholesaler automotive Big Z Inc. wants to create the analytical database idata warehouse) to analyze its order quantitis depot zip onder clerk, including * order clerk id . order clerk name The twoavailable data sources, Source 1 and Source 2 are described below Source 1 The Big Z Inc. Human Resounces Department Source 2 The Big Z Inc. Orders Database, shown in order clerk title Table, shown in Figure 8.47 . order clerk education level order clerk year of hire Figure 8.48 E8.3a Based on the sources and requirements listed The data warehouse has to enable an analysis of order quantities by date, including above, create a dimensional model that will be used for the dimensionally modeled data ware- house for Big Z Inc. E8.3b Using data from Figures 8.47 and 8.48, illustrate EX.3c Based on the sources and requinements listed abowe E83d Using data from Figures 8.47 and 8.48, illustrabe e full dabe e day of week how the tables in the dimensional model creabd in E8.3a would be populated. day of month . month create an ER model and a mapped relational model for the noemalized data warchouse for Big Z Inc quarter e year how the tables in the relational model created in ES.k would be populated * peoduct, including product ID product name HUMAN RESOURCES DEPARTMENT TABLE (EMPLOYEE DATA) EmpioyeelD Name Title Antonio Ondor Clok High School FIGURE 8.47 Source 1: The Big Z Inc. Human Resources Department Table. Calendar Customer FullDate DayOfWeek DayOfMonth Month Quarter Year CustomerID CustomerName CustomerType Order Quantity fact table CalendarKey FK) ProductKey (FK) CustomerKey (FK) DepotKey (FK) OCKey (FK) OrderID Time Quant Product tKe ProductID ProductName ProductType SupplierName OrderCleark OCKey OCID OCName OCTitle OcEducation OCYofhire DepotID DepotSize De