Using the data in Figure A, how to fill the tables shown in Figure B

FIGURE A: REGION Regioni RegionName Chicagoland T Tristate PRODUCT ProductID Product Name Product Price 1X1 Zu Bag $105 2x2 Easy Boot $65 3x3 Cosy Sock $10 4X4 Dura Boot $95 5X5 Tiny Tent $140 6X6 Bigay Tent $240 VENDOR Vendorld Vendor Name PG Pacifica Gear MK Mountain King MK Vendorld CategoryID PG CP FW MK FW PG FW MK CP MK STORE Storeld StoreZip RegionID 51 60600 S2 80605 S3 35400 T CATEGORY Categoryid CategoryName CP Camping FW Footwear SALESTRANSACTION TID Customer StorelD TDate TTime T101 3-4-555 S3 1-Jan-2013 8:00:00 AM T102 1-2 333 S2 2-Jan-2013 8:00:00 AM T103 2-3-444 S2 2-Jan-2013 8:15:00 AM T1041-2-333 SI 2-Jan-2013 8.30:00 AM T1052-3-444 S3 3-Jan-2013 0:00:00 AM T1063-4-555 S2 3-Jan-2013 8:15:00 AM T1071-2-333 S2 3-Jan-2013 8:30:00 AM CUSTOMER Customer D CustomerName CustomerZip 1-2-333 Tina B0137 2-3-444 Tony 60511 3-4-555 Pam 35401 SOLDVIA ProductiD TID NoOfitems 6X6 T1011 5X5 T1012 1X1 T1011 3x3 T1023 4X4 T1021 4X4 T1031 2x2 T1041 3X3 T1054 4X4 T1061 3x3 T1065 3X3 T1073 FIGURE B: CALENDAR Dimension Calendar Key FullDate Dayor PRODUCT Dimension ProductKey ProductiD Product Name Day of Month Otr Year Month Week Product Product Price Vendor Name Product Category Name STORE Dimension StoreKey StorelD StoreZip Store Region Store Store Name Size (m) CSystem Store Layout CUSTOMER Dimension CustomerKey Customerld Customer Name Customer Customer Customer Zip Gender Marital Status Customer Education Level Customer CreditScore SALES Fact table Calendar Key StoreKey ProductKey Customerkey TID TimeOfDay Dollars Sold Units Sold