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...
-
List some major differences between the taxation of individuals and trusts.
-
Rerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as...
-
Briefly explain the accounting and reporting for loss contingencies.
-
You are evaluating audit results for assets in the audit of Roberts Manufacturing. You set the preliminary judgment about materiality at $50,000. The account balances, tolerable misstatement, and...
-
Core 1 ?? Practice Case 2 Case (60 minutes) Costume Crazy Inc. (CCI) is a privately held chain of specialty costume rental stores headquartered in Toronto, Ontario. The company was incorporated in...
-
For Simonsen Village, prepare a government-wide statement of net position and statement of activities, and a governmental funds balance sheet and statement of revenues, expenditures, and changes in...
-
As per usual UCF is working on expanding the outside eating location outside the Student Union. They have set up chairs on a linear path that extends quite far. To prevent the engineering students...
-
The effect of an impulse applied to a SDOF system is to cause a discrete change in displacement. Indicate whether the statement presented is true or false. If true, state why. If false, rewrite the...
-
The convolution integral is the solution to the differential equation governing the motion of a SDOF system with initial conditions equal to zero. Indicate whether the statement presented is true or...
-
The equations are ___________ using mode shape ___________ with respect to ___________ and ___________. Regarding the derivation of modal analysis for an undamped system or a system with proportional...
-
The vector of forces for the right-hand side of the equations defining the principal coordinates is calculated by \(\mathbf{G}=\mathbf{P}^{T} \mathbf{F}\). Indicate whether the statement presented is...
-
The elements of the impedance matrix are the transfer functions \(G_{i, j}(s)\). Indicate whether the statement presented is true or false. If true, state why. If false, rewrite the statement to make...
-
A company purchases merchandise with a catalog price of $29,000. The company receives a 35% trade discount from the seller. The seller also offers credit terms of 2/10, n/30. Assuming no returns were...
-
Design an experiment to demonstrate that RNA transcripts are synthesized in the nucleus of eukaryotes and are subsequently transported to the cytoplasm.
-
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...
-
Following are the elements of the planning process as discussed in this chapter, with some characteristics pertaining to those elements. a. Goals b. Strategic plan c. Capital budget d. Operating...
-
The Byrne Company is in the process of determining a return rate to use for its cost of capital. Upon review of the financial statements it was determined that the total interest bearing debt is...
-
The Cunningham Company is in the process of determining a return rate to use for its cost of capital. Upon review of the financial statements it was determined that the total interest bearing debt is...
Study smarter with the SolutionInn App