1. 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.
2. 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.
3. 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.

Product Price REGION Region ID RegionName Chicagoland T Tristate $100 VendorID CategoryID PG CP MK FW $70 PRODUCT ProductID ProductName 1X1 Zzz Bag 2X2 Easy Boot 3X3 Cosy Sock 4X4 Dura Boot Tiny Tent 6X6 Biggy Tent MK FW STORE $15 $90 FW 5X5 $150 MK Region ID CP $250 MK CP StoreID StoreZip S1 60600 S2 60605 S3 35400 T VENDOR VendorID Vendor Name PG Pacifica Gear MK Mountain King StoreID TTime SALESTRANSACTION TID CustomerID T101 3-4-555 T102 1-2-333 T103 2-3-444 S3 S2 S2 TDate 1-Jan-2020 2-Jan-2020 2-Jan-2020 2-Jan-2020 3-Jan-2020 3-Jan-2020 3-Jan-2020 T104 1-2-333 S1 8:00:00 AM 8:00:00 AM 8:15:00 AM 8:30:00 AM 8:00:00 AM 8:15:00 AM 8:30:00 AM CATEGORY CategoryID Category Name CP Camping FW Footwear T105 S3 T106 2-3-444 3-4-555 1-2-333 S2 T107 S2 INCLUDES CUSTOMER ProductID TID CustomerID Customer Quantity 1 Customer Name T101 Zip 6X6 5X5 1-2-333 Tina 60137 2 T101 T101 2-3-444 60611 1X1 1 Tony Pam 35401 3x3 3-4-555 T102 3 4X4 T102 1 4X4 T103 1 2X2 T104 1 3X3 T105 4 4X4 T106 1 T106 5 3X3 3X3 T107 3 CALENDAR Dimension Calendarkey FullDate DayorWeek DayOfMonth Month Qtr Year STORE Dimension Store Key StoreID Store Zip StoreSize Store Region Name Store CSystem Store Layout CUSTOMER Dimension Customer Key CustomerID Customer Name Customer Zip Customer Marital Status Customer Education Level Customer Credit Score PRODUCT Dimension ProductKey ProductID Product Name Product Price Product Vendor Name Product Category Name SALES Fact table Calendar Key StoreKey ProductKey Customer Key TID TimeOfDay DollarsSold UnitsSold Product Price REGION Region ID RegionName Chicagoland T Tristate $100 VendorID CategoryID PG CP MK FW $70 PRODUCT ProductID ProductName 1X1 Zzz Bag 2X2 Easy Boot 3X3 Cosy Sock 4X4 Dura Boot Tiny Tent 6X6 Biggy Tent MK FW STORE $15 $90 FW 5X5 $150 MK Region ID CP $250 MK CP StoreID StoreZip S1 60600 S2 60605 S3 35400 T VENDOR VendorID Vendor Name PG Pacifica Gear MK Mountain King StoreID TTime SALESTRANSACTION TID CustomerID T101 3-4-555 T102 1-2-333 T103 2-3-444 S3 S2 S2 TDate 1-Jan-2020 2-Jan-2020 2-Jan-2020 2-Jan-2020 3-Jan-2020 3-Jan-2020 3-Jan-2020 T104 1-2-333 S1 8:00:00 AM 8:00:00 AM 8:15:00 AM 8:30:00 AM 8:00:00 AM 8:15:00 AM 8:30:00 AM CATEGORY CategoryID Category Name CP Camping FW Footwear T105 S3 T106 2-3-444 3-4-555 1-2-333 S2 T107 S2 INCLUDES CUSTOMER ProductID TID CustomerID Customer Quantity 1 Customer Name T101 Zip 6X6 5X5 1-2-333 Tina 60137 2 T101 T101 2-3-444 60611 1X1 1 Tony Pam 35401 3x3 3-4-555 T102 3 4X4 T102 1 4X4 T103 1 2X2 T104 1 3X3 T105 4 4X4 T106 1 T106 5 3X3 3X3 T107 3 CALENDAR Dimension Calendarkey FullDate DayorWeek DayOfMonth Month Qtr Year STORE Dimension Store Key StoreID Store Zip StoreSize Store Region Name Store CSystem Store Layout CUSTOMER Dimension Customer Key CustomerID Customer Name Customer Zip Customer Marital Status Customer Education Level Customer Credit Score PRODUCT Dimension ProductKey ProductID Product Name Product Price Product Vendor Name Product Category Name SALES Fact table Calendar Key StoreKey ProductKey Customer Key TID TimeOfDay DollarsSold UnitsSold