PART 2

Using the data in Figure A, illustrate how the tables in the dimensional model shown in Figure B would be populated.

IGURE A: REGION Region Region Name Chicagoland Tristate VENDOR Vendorld Vendor Name PG Pacifica Gear MK Mountain King PRODUCT Products ProductName ProductPrice Vendorld CategoryID 1X1 Zur Bag $105 PG 2x2 Easy Boot $65 MK FW 3x3 Cosy Sock $10 MK FW 4X4 Dura Boot $95 PG FW 5X5 Tiny Tent $140 MK CP 6X6 Bigay Tent $240 MK CP STORE StoreID Store Zip RegionID S1 60600 S2 BOBO5 C S3 35400 T CATEGORY Category CategoryName CP Camping FW Footwear CUSTOMER Customer CustomerName Customerzip 1-303 Tina 80137 23444 Tony 60011 3.4.555 95401 SALESTRANSACTION TID Customer StoreID TDate TTime T10134.65 SO 1 2013 18:00 DO AM T19:33 32 2 2013 8:00:00 AM T10312 3444 52 2 2013 1815 DO AM 1104 1-2-339 S1 in 2013 8:30:00 AM TI02-3-444 S3 3 Jan 2013 00:00 AM T10434855 S2 Jan 2018! 8 15:00 AM 1102112323 2013 830 00 AM SOLDVIA ProductD TID Noottoms EX Y1011 5X TOT 1X To 3x3 TO 4X4 TIDO 4X4 T13 2x T1041 3x 11054 4X4 T106 1 ax TE ax TIF 3 92 FIGURE B: CALENDAR Dimension Calendarkey FullDate Dayot Week Day of Month Or Year Month PRODUCT Dimension Product Key Productio Product Name Product Product Price Vendor Name Product Category Name STORE Dimension StoreKey StorelD Store Zip Store Region Store Store Name Sie im cSystem Store Layout CUSTOMER Dino Customerkey Customer Customer Customer Customer Customer Name Zip Gender Martastatus Customer Education level Customer CreditScore SALES Factable Store Produse Customerkey TID Time ore Dollars Sold Union