rn E8.3 Consider the following scenario involving Big Z Inc., an automotive products wholesaler. Big Z Inc.
Fantastic news! We've Found the answer you've been seeking!
Question:
rn
Transcribed Image Text:
E8.3 Consider the following scenario involving Big Z Inc., an automotive products wholesaler. Big Z Inc. wants to create the analytical database (data warehouse) to analyze its order quantities. The two available data sources, Source 1 and Source 2, are described below. Source 1 The Big Z Inc. Human Resources Department Table, shown in Figure 8.47. Source 2 The Big Z Inc. Orders Database, shown in Figure 8.48. The data warehouse has to enable an analysis of order quantities by: • date, including: • full date day of week day of month • month • quarter • year • time • product, including: • product ID • product name • product type • product supplier name • customer, including: • customer ID • customer name • customer type • customer zip depot, including: depot ID • depot size • depot zip • order clerk, including: • order clerk id • order clerk name order clerk title • order clerk education level order clerk year of hire E8.3a Based on the sources and requirements listed above, create a dimensional model that will be used for the dimensionally modeled data warehouse for Big Z Inc. E8.3b Using data from Figures 8.47 and 8.48, illustrate how the tables in the dimensional model created in E8.3a would be populated. HUMAN RESOURCES DEPARTMENT TABLE (EMPLOYEE DATA) Education Level YearOfHire EmployeelD Name Antonio Wesley Lilly OC1 OC2 OC3 Title Order Clerk Order Clerk Order Clerk High School College College FIGURE 8.47 Source 1: The Big Z Inc. Human Resources Department Table. 2001 2005 2005 DepotZip DepotSize OCName DEPOT D1 D2 D3 DepotID ORDERCLERK H Small Large Large C1 C2 C3 OCID DEPOT DepotID DepotSize DepotID DepotSize DepotZip OCID OCName OC1 Antonio OC2 Wesley OC3 Lilly DEPOT OCID OCName LATT ORDER OrderID OrderDate ORDERCLERK ORDERCLERK ORDER ShipsFrom DepotZip 60611 60660 60611 01 02 03 04 05 06 CUSTOMER CustomerID CustomerName Auto Doc Bo's Car Repair JJ Auto Parts Processes ProductID OrderID CustomerID C1 C2 C3 C1 C2 C3 P1 P2 P3 ProductName PRODUCT ProductID Quantity D1 D1 D2 D2 D3 D3 CustomerType Repair Shop Repair Shop Retailer PRODUCT Includes PRODUCT ProductID ProductName Product Type SupplierID (FK) ORDEREDVIA ProductID (FK) OrderID (FK) Quantity Product Type ORDER OrderID OrderDate Order Time CustomerID (FK) DepotID (FK) OCID (FK) CustomerZip 60137 60140 60605 Product Name ProductType BigGripper Traction Wiz SureStart Tire Tire Battery Order Time DepotID OCID OrderDate Order Time OC1 1-Jan-2013 9:00:00 AM OC2 2-Jan-2013 9:00:00 AM OC3 2-Jan-2013 9:30:00 AM OC1 3-Jan-2013 9:00:00 AM OC2 3-Jan-2013 9:15:00 AM OC3 3-Jan-2013 9:30:00 AM Supplies Submits Supplier D ST ST BE SUPPLIER SupplierID SupplierName CustomerZip CUSTOMER CustomerID CustomerName CustomerType CustomerZip P1 P2 P1 P2 P3 P3 P2 P1 CustomerID CustomerName 000 ST BE SupplierID SUPPLIER 01 01 02 03 04 05 SupplierName 06 06 CUSTOMER SUPPLIER SupplierID SupplierName Super Tires Batteries Etc ORDEREDVIA ProductID OrderID Quantity CustomerType 4 8 12 4 7 5 8 4 E8.3 Consider the following scenario involving Big Z Inc., an automotive products wholesaler. Big Z Inc. wants to create the analytical database (data warehouse) to analyze its order quantities. The two available data sources, Source 1 and Source 2, are described below. Source 1 The Big Z Inc. Human Resources Department Table, shown in Figure 8.47. Source 2 The Big Z Inc. Orders Database, shown in Figure 8.48. The data warehouse has to enable an analysis of order quantities by: • date, including: • full date day of week day of month • month • quarter • year • time • product, including: • product ID • product name • product type • product supplier name • customer, including: • customer ID • customer name • customer type • customer zip depot, including: depot ID • depot size • depot zip • order clerk, including: • order clerk id • order clerk name order clerk title • order clerk education level order clerk year of hire E8.3a Based on the sources and requirements listed above, create a dimensional model that will be used for the dimensionally modeled data warehouse for Big Z Inc. E8.3b Using data from Figures 8.47 and 8.48, illustrate how the tables in the dimensional model created in E8.3a would be populated. HUMAN RESOURCES DEPARTMENT TABLE (EMPLOYEE DATA) Education Level YearOfHire EmployeelD Name Antonio Wesley Lilly OC1 OC2 OC3 Title Order Clerk Order Clerk Order Clerk High School College College FIGURE 8.47 Source 1: The Big Z Inc. Human Resources Department Table. 2001 2005 2005 DepotZip DepotSize OCName DEPOT D1 D2 D3 DepotID ORDERCLERK H Small Large Large C1 C2 C3 OCID DEPOT DepotID DepotSize DepotID DepotSize DepotZip OCID OCName OC1 Antonio OC2 Wesley OC3 Lilly DEPOT OCID OCName LATT ORDER OrderID OrderDate ORDERCLERK ORDERCLERK ORDER ShipsFrom DepotZip 60611 60660 60611 01 02 03 04 05 06 CUSTOMER CustomerID CustomerName Auto Doc Bo's Car Repair JJ Auto Parts Processes ProductID OrderID CustomerID C1 C2 C3 C1 C2 C3 P1 P2 P3 ProductName PRODUCT ProductID Quantity D1 D1 D2 D2 D3 D3 CustomerType Repair Shop Repair Shop Retailer PRODUCT Includes PRODUCT ProductID ProductName Product Type SupplierID (FK) ORDEREDVIA ProductID (FK) OrderID (FK) Quantity Product Type ORDER OrderID OrderDate Order Time CustomerID (FK) DepotID (FK) OCID (FK) CustomerZip 60137 60140 60605 Product Name ProductType BigGripper Traction Wiz SureStart Tire Tire Battery Order Time DepotID OCID OrderDate Order Time OC1 1-Jan-2013 9:00:00 AM OC2 2-Jan-2013 9:00:00 AM OC3 2-Jan-2013 9:30:00 AM OC1 3-Jan-2013 9:00:00 AM OC2 3-Jan-2013 9:15:00 AM OC3 3-Jan-2013 9:30:00 AM Supplies Submits Supplier D ST ST BE SUPPLIER SupplierID SupplierName CustomerZip CUSTOMER CustomerID CustomerName CustomerType CustomerZip P1 P2 P1 P2 P3 P3 P2 P1 CustomerID CustomerName 000 ST BE SupplierID SUPPLIER 01 01 02 03 04 05 SupplierName 06 06 CUSTOMER SUPPLIER SupplierID SupplierName Super Tires Batteries Etc ORDEREDVIA ProductID OrderID Quantity CustomerType 4 8 12 4 7 5 8 4
Expert Answer:
Answer rating: 100% (QA)
Solution E83a Calendar CalendarKey FullDate DayOfWeek DayOfMonth Month Quarter Year Cus... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-0077861629
8th edition
Authors: Richard Brealey, Stewart Myers, Alan Marcus
Posted Date:
Students also viewed these databases questions
-
The norm of a linear transformation TA: Rn Rn can be defined by where the maximum is taken over all nonzero x in Rn. (The subscript indicates that the norm of the linear transformation on the left is...
-
Suppose that f: Rn R and g: Rn Rn are differentiable on Rn and that there exist r > 0 and a Rn such that Dg(x) is the identity matrix, I, for all x Br(a). Prove that there is a function h: Br(a) {a}...
-
Let 5: Rn Rn and T: Rn Rn be linear transformations with matrices A and B respectively. [Theorem 3.] (a) Show that B2 = B if and only if T2 = 7 (where T2 means T o T). (b) Show that B2 = 1 if and...
-
Jefferson Company purchased a piece of equipment on January 1, 2014. The equipment cost $60,000 and has an estimated life of 8 years and a salvage value of $8,000. What was the depreciation expense...
-
A study noted that the mean life span for 35 male symphony conductors was 73.4 years, in contrast to the mean of 69.5 years for males in the general population. The longer life span was attributed to...
-
The wind power density is the power in the wind per unit area. Using your learning resources, calculated the wind power density given an air density of 1.16 kg/m 3 and a windspeed of 3.9 m/s,
-
Data, collected from cities of widely varying sizes, revealed a high positive correlation between the amount of beer consumed and the number of weddings in the past year. Will consuming lots of beer...
-
Hartman Inc. issues 500 shares of $10 par value common stock and 100 shares of $100 par value preferred stock for a lump sum of $100,000. (a) Prepare the journal entry for the issuance when the...
-
A cannon is fired with muzzle velocity of 158 m/s at an angle of elevation = 46. Gravity = 9.8 m/s 2 . a) What is the maximum height the projectile reaches? b) What is the total time aloft? c) How...
-
This chapter discusses the data dictionary views for Oracle 12c. Research another RDBMS, such as Microsoft SQL Server, and report on its data dictionary facility and how it compares with Oracle.
-
In Chapter 8 Actions of Disrupted: My Misadventure in the Start-Up Bubble , Lyons talks about "The Bozo Explosion" and how it impacts that kinds of people that end up working at HubSpot. These bozos,...
-
Explain the link between the MarshallLerner condition and the J-curve.
-
Explain how non-government organizations operate as a means of promoting economic development.
-
Distinguish between economic growth and economic development.
-
a. What is meant by tick size? b. What is the tick size for common stock?
-
Explain expenditure-switching as a means to correct a current account deficit.
-
Several years ago, Timmins Inc. issued $250,000 of 10-year bonds at a discount. The company decides to redeem the bonds at 98 when the amortized cost is $248,000. Would there be a gain or a loss on...
-
An auto-parts manufacturer is considering establishing an engineering computing center. This center will be equipped with three engineering workstations each of which would cost $25,000 and have a...
-
Consider this simplified balance sheet for Geomorph Trading: a. What is the company's debt-equity ratio? b. What is the ratio of total long-term debt to total long-term capital? c. What is its net...
-
You will receive $100 from a savings bond in 3 years. The nominal interest rate is 8%. (L05-5) a. What is the present value of the proceeds from the bond? b. If the inflation rate over the next few...
-
Strip Mining Inc. can develop a new mine at an initial cost of $5 million. The mine will provide a cash flow of $30 million in 1 year. The land then must be reclaimed at a cost of $28 million in the...
-
The tube is subjected to a torque of 750 N. m. Determine the amount of this torque that is resisted by the gray shaded section. Solve the problem two ways: (a) by using the torsion formula, (b) by...
-
The solid shaft has a diameter of 0.75 in. If it is subjected to the torques shown, determine the maximum shear stress developed in regions BC and DE of the shaft. The bearings at A and F allow free...
-
The solid shaft has a diameter of 0.75 in. If it is subjected to the torques shown, determine the maximum shear stress developed in regions CD and EF of the shaft. The bearings at A and F allow free...
Study smarter with the SolutionInn App