Question: Using data in figure A , fill tables in figure B FIGURE A: REGION RegionlD RegionName Chicagoland T Tristate VENDOR VendorID Vendor Name Pacifica Gear

FIGURE A: REGION RegionlD RegionName Chicagoland T Tristate VENDOR VendorID Vendor Name Using data in figure A , fill tables in figure B

FIGURE A: REGION RegionlD RegionName Chicagoland T Tristate VENDOR VendorID Vendor Name Pacifica Gear MK Mountain King Zzz Bag PG PG PRODUCT ProductID Product Name ProductPrice Vendorld CategoryID 1X1 $105 2x2 Easy Boot $65 MK FW 3x3 Cosy Sock $10 MK FW Dura Boot PG FW 5X5 Tiny Tent $140 MK CP 6X6 Bigay Tent $240 MK CP 4X4 $95 STORE Storeld Store Zip RegionID S1 60600 S2 60605 S3 35400 T CATEGORY Category CategoryName CP Camping FW Footwear CUSTOMER Customer CustomerName Customer Zip 1-2-333 Tina B0137 2-3-444 60611 3-4-555 Pam 35401 SALESTRANSACTION TID Customer D StorelD TDate TTime T1013-4-555 S3 1-Jan-2013 8:00:00 AM T102 1-2-333 S2 2Jan-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 T105 2-3-444 S3 3-Jan-2013 8:00:00 AM T1063-4-555 S2 3-Jan-2013 8:15:00 AM T107 1-2-333 S2 3-Jan-2013 8:30:00 AM Tony SOLDVIA ProductiD TID NoOfitems 6X6 T1011 5X5 T1012 1X1 T1011 3x3 T1023 4X4 T1021 4X4 T1031 2x2 T1041 3x3 T105 4 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 Product Category Name Name STORE Dimension Storekey StorelD Store Zip Store Region Store Store Name Size (m) CSystem Store Layout CUSTOMER Dimension CustomerKey Customer Customer Customer Customer Customer Name Zip Gender MaritalStatus Customer Education Level Customer CreditScore SALES Fact table Calendar Key Storekey ProductKey CustomerKey TID TimeOfDay Dollars Sold Units Sold

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!

Postgres Questions regarding the tables above. Thank you in advance! "E5.1.17 Display the RegionID, RegionName, and the total amount of sales (in dollars) in the region for all regions. Display the...

The Questions needing answered are the highlighted portions, dont use INNER JOIN, LEFT JOIN, RIGHT JOIN VENDOR REGION RegionID RegionName Chicagoland T Tristate INCLUDES ProductID 1x1 TID Quantity 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. E8.1b Create a dimensional model containing an aggregated fact table,...

Submit a single SQL query statement for each of the following questions: 1. Display the SMemberID and SMemberName of staff members cleaning apartments rented by corporate clients whose corporate...

E6.5 Show the PRODUCT table from Figure 3.33 in Chapter 3 accompanied by a PRODUCTNAME_INDEX table, using the ProductID value as the index pointer. INCLUDES m VENDOR VendorID ProductID TID Vendor...

USING CODE IN SQL, write a query statement that satisfy's the following: 1. Display the SMemberID and SMemberName of staff members cleaning apartments rented by corporate clients whose corporate...

Show the PRODUCT table from the figure provided accompanied by a PRODUCTNAME_INDEX table, using the ProductID value as the index pointer. Use SQL. *Make the PRODUCT table accompanied by a...

(Please follow the insturction below using the table above) 1. Create a new query. Select all columns from the Customer Table 2. Create a new query. Select StoreID, StoreZip, and RegionName from the...

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

Please tell me how to create these tables in sql. (So I mean tell me their data types, the types of their keys and whether they are null or not null) REGION INCLUDES VENDOR \begin{tabular}{|l|l|}...

When phenyl isothiocyanate, C6H5N == C == S, is reduced with lithium aluminum hydride, the product formed has these spectral data: MS (m/z): 107, 106 IR (cm-1): 3330 (sharp), 3050, 2815, 760, 700 1H...

7.7 Rates of ozone decomposition are retarded by carbonate ions, which act as hydroxyl radical scavengers. Three sets of batch data collected at pH 7.0 with the same carbonate concentration (0.01...

Why are special - purpose vehicles ( SPVs ) commonly established in various jurisdictions as part of a leveraged buyout ( LBO ) deal structure?

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

4. Design a management development program for first-level supervisors in a mass-market retail company. What courses and experiences do they need?

LO1 Identify why performance management is necessary.

3. How does the overtone of military-style training impact Walmarts employment brand? Would this appeal to particular segments of the labor force? How might it impact the companys ability to recruit...