"Exercises E8.1 Consider the following, slightly modified, ZAGI Retail Company scenario. The ZAGI Retail Company wants to create an analytical database to analyze sales. The three available data sources are: Source 1 The ZAGI Retail Company Sales Department Database shown in Figure 8.2 (with expansion shown in Figure 8.13) and 8.37. In other words, the schema remains the same as in Figure 8.2 (with expansion shown in Figure 8.13) but the data is different, as shown in Figure 8.37 below. Source 2 The ZAGI Retail Company Facilities Department Database shown in Figure 8.6 Source 3 A Customer Demographic Data external table shown in Figure 8.7 The data warehouse has to enable an analysis of sales dollar amounts and quantities by: date, including: full date day of week day of month month quarter year time product, including: product name and price product category product vendor customer, including: customer name zip gender marital status education level credit score store, including: individual store store size store zip store checkout system store layout store region Figure 8.15 illustrates how a sales analysis data warehouse based on these sources and requirements would be designed if the dimensional modeling technique were used. E8.1a Using the data in Figure 8.37, illustrate how the tables in the dimensional model shown in Figure 8.38 would be populated. E8.1b Create a dimensional model containing an aggregated fact table, where a fact table shows a summary of units sold and dollars sold for daily purchases of each product in each store. E8.1c Populate the tables created in E8.1b with the data. Use the data that you used to populate the tables shown in the Figure 8.38 as the basis for aggregation. Figure 8.37 Source 1: The ZAGI Retail Company Sales Department Database data set (a different data set) Figure 8.38