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

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

Using the data in Figure A, illustrate how the tables in the dimensional model shown in Figure B would be populated. FIGURE A: : REGION RegionID Region Name Chicagoland T Tristate VENDOR Vendorld Vendor Name PG Pacifica Gear MK Mountain King PRODUCT ProductID ProductName ProductPrice Vendorio CategoryID 1X1 Zzz Bag $105 PG CP 2x2 Easy Boot $65 MK FW Cosy Sock $10 MK FW 4X4 Dura Boot $95 PG FW 55 Tiny Tent MK CP 6X6 Biggy Tent $240 MK CP $140 STORE StorelD Store Zip Regionid S1 60600 S2 60605 S3 35400 T CATEGORY CategoryID CategoryName CP Camping Footwear FW CUSTOMER Customerld Customer Name Customer Zip 1-2-333 Tina 60137 2-3-444 Tony 3-4-555 Pam 35401 SALESTRANSACTION TID CustomerlD 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 T104 1-2-333 S1 2-Jan-2013 8:30:00 AM T1052-3-444 S3 3-Jan-2013 8:00:00 AM T106 / 3-4-555 S2 3-Jan-2013 8:15:00 AM T1071-2-333 S2 3-Jan-2013 8:30:00 AM 60611 SOLDVIA ProductID TID No Ofitems 6X6 T101 1 5X5 T1012 1X1 T101 1 3X3 T1023 4X4 T1021 4X4 T1031 2x2 T1041 3X3 T1054 4X4 T1061 3X3 T1065 3X3 T1073 FIGURE B: CALENDAR Dimension CalendarKey FullDate Dayof Week Dayor Month atr Year Month PRODUCT Dimension ProductKey Product Product Name Product Product Price Vendor Name Product Category Name STORE Dimension StoreKey StorelD StoreZip Store Region Store Store Store Name Size (m) CSystem Layout CUSTOMER Dimension CustomerKey Customer Customer Customer Customer Customer Zip Gender Customer Education Level Customer CreditScore Name MaritalStatus SALES Fact table Calendar Key Storekey ProductKey Customerkey TID TimeOfDay DollarsSold UnitsSold

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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,...

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...

a. Using the data in Figure 8.41, illustrate how the tables in the dimensional model shown in Figure 8.42 would be populated. b. Create a dimensional model containing an aggregated fact table, where...

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...

USING SQL DATA DEFINITION LANGUAGE TO CREATE TABLES, ALTER TABLES, INSERT RECORDS For this lab, ALL of the tasks will be done with SQL by creating SQL Scripts (queries) in the NEW SQL QUERY window....

Solve question e8.3b 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 *...

Solve Question E8.3a please 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...

Solve question e8.3b 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 *...

I don't know how to slove this one and that is all of what I have. Please help me! Thank you so much The description and tables below are provided to support a new data warehouse for ZAGI Retail...

Refer to the American Business Review (Jan. 2002) comparison of large-cap, medium-cap, and small-cap mutual funds, Exercise 9.26 (p. 509). Using an experiment-wise error rate of .05, Tukey confidence...

At the end of the term, university and college students often complete questionnaires about their courses. Suppose that in one university, students were asked the following. a. Rate the course...

Which of the following is traded in the money market? A . Long term securities B . Coins C . Highly liquid securities D . Paper notes

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

2 To what extent is there alignment of strategy in the supply chains for these two products?

1 How did inventory reduction in the supply chain lead to improved competitiveness at Xerox? Once the problems of introducing just-in-time production systems had been solved at the Xerox plant making...

Select the top two product lines (in terms of sales) for your firm or one that you know well. Using the headings in Table 1.1, fill in the details for characteristics of both product lines. Aim to...