1. Create the relationships necessary among the three tables. Use the following ER diagram (Exhibit 4.42)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Create the relationships necessary among the three tables. Use the following ER diagram (Exhibit 4.42) as a guide: Raw_Materials Raw Materia's Code Raw Materials, Description Raw Materiais Price Purchase Orders Purchese Order D Purdhese Order Date Suppliers 1 Supplier ID Supplier Company name Supplier Address Supplier.City Supplier St Supplier. Zip Purchase Employee.ID Supplier D Raw Materials Code Quantity Purchased 2. Create a pivot table (make sure to place a check mark in the box to add the data to the Data Model when inserting the pivot table). 3. In the pivot table, add the following fields: Raw_Materials_Description (rows), Supplier_St (rows), and a count of Purchase_Order_ID (Values). Ask the Question: How can we pull in descriptive attributes from separate tables into the transaction table that we wish to use for analysis? Master the Data: Apply the same steps as Lab 4-4 to the Lab 4-4 Alt Data.xlsx dataset. The 4-4 Alt dataset contains three tables related to the purchasing process. Build the relationships in Excel so that you can create a pivot table using all three tables. Software needed · Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Lab 4-4 Alt Data.xlsx. Perform the Analysis: Refer to Lab 4-4 Alternative in the text for instructions and Lab 4-4 steps foreach the of lab parts. Share the Story: Because of the relationships that you built, you can build pivot tables with any of the fields from all three tables. H Purchase_Order_ID - Purchase_Order Date Purchase_Employee ID Suppller ID Raw Materlals Code Quantity Purchased Raw Materlal Purchase Price 20500 11/1/19 1009 3 1001 3 19,99 20501 11/5/19 11/10/19 1009 2 1003 10 29 20502 1009 1003 29 20503 11/13/19 1008 1 1002 12 44.99 20504 11/16/19 1009 1001 4 19.99 11/19/19 11/23/19 11/23/19 11/26/19 11/29/19 20505 1008 2 1001 12 19.99 20506 1009 1 1001 5 19.99 20506 1009 1 1003 29 20507 1009 1 1001 19.99 20508 1009 3 1 1001 4 19.99 12/4/19 12/9/19 20509 1009 1 1001 12 19.99 20510 1009 2 1001 11 19.99 12/12/19 12/16/19 12/19/19 20511 1008 3 1003 6 29 20512 1009 3 1001 7 19.99 20513 1008 1002 11 44.99 20514 12/24/19 1009 3. 1002 11 44.99 20515 12/28/19 1009 1 1002 4 44.99 20516 1/2/20 1008 1 1003 11 29 20517 1/5/20 1009 2 1001 10 19.99 20518 1/9/20 1009 1 1003 12 29 20519 1/14/20 1008 2 1001 1 19.99 20520 1/18/20 1008 1 1003 12 29 20521 1/23/20 1008 3 1001 6 19.99 20522 1/26/20 1009 3 1002 10 44.99 20523 1/31/20 1009 1 1001 8. 19.99 20524 2/4/20 1009 2 1001 1 19.99 20525 2/8/20 1008 3 1002 5 44.99 2/8/20 2/8/20 20525 1009 1002 2 44.99 20525 1008 3 1003 6 29 20526 2/13/20 1009 2 1001 11 19.99 20527 2/16/20 1009 2 1001 12 19.99 20527 2/16/20 1009 2 1003 6 29 20528 2/21/20 1008 1 1001 3 19.99 20529 2/24/20 1008 3 1003 10 29 2/28/20 2/28/20 20530 1008 3 1001 2 19.99 20530 1009 3 1003 2 29 20531 3/4/20 1008 3 1003 29 20532 3/7/20 1008 1 1002 2 44.99 20533 3/12/20 1009 1 1002 12 44.99 3/15/20 3/19/20 20534 1008 2 1002 5 44.99 20535 1009 3 1002 44.99 3/23/20 3/27/20 20536 1009 2 1001 12 19.99 20537 1008 1003 6. 29 3/31/20 4/4/20 20538 1009 1 1002 5 44.99 20539 1008 3 1003 29 20540 4/8/20 1008 2 1001 3 19.99 20541 4/11/20 1009 3 1003 10 29 20541 4/11/20 1008 3 1003 3 29 20542 4/14/20 1009 1 1003 29 20542 4/14/20 1009 1 1002 44.99 20543 4/18/20 1009 1 1002 1 44.99 20544 4/21/20 1008 2 1002 44.99 Required: 1. What is the Foreign Key in the Purchase_Orders table that allows you to relate it to the Suppliers table? O Customer_ID O Employee_ID O Purchase_Order_ID O Supplier_ID 2. What is the Foreign Key in the Purchase_Orders table that allows you to relate it to the Raw_Materials table? O Customer_ID O Raw_Materials_Code O Supplier_ID O Purchase_Order_ID 3. How many Purchase Orders for Hops were created for suppliers in Arkansas? O 52 O 5 O 4 8 0 4. How many Purchase Orders were created for suppliers in Arkansas (for any products)? O 18 O 5 O 52 O8 5. Change the PivotTable so that you see the sum of quantity purchased associated with each product and state. What was the quantity of hops purchased from suppliers in Minnesota? 28 42 344 50 1. Create the relationships necessary among the three tables. Use the following ER diagram (Exhibit 4.42) as a guide: Raw_Materials Raw Materia's Code Raw Materials, Description Raw Materiais Price Purchase Orders Purchese Order D Purdhese Order Date Suppliers 1 Supplier ID Supplier Company name Supplier Address Supplier.City Supplier St Supplier. Zip Purchase Employee.ID Supplier D Raw Materials Code Quantity Purchased 2. Create a pivot table (make sure to place a check mark in the box to add the data to the Data Model when inserting the pivot table). 3. In the pivot table, add the following fields: Raw_Materials_Description (rows), Supplier_St (rows), and a count of Purchase_Order_ID (Values). Ask the Question: How can we pull in descriptive attributes from separate tables into the transaction table that we wish to use for analysis? Master the Data: Apply the same steps as Lab 4-4 to the Lab 4-4 Alt Data.xlsx dataset. The 4-4 Alt dataset contains three tables related to the purchasing process. Build the relationships in Excel so that you can create a pivot table using all three tables. Software needed · Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Lab 4-4 Alt Data.xlsx. Perform the Analysis: Refer to Lab 4-4 Alternative in the text for instructions and Lab 4-4 steps foreach the of lab parts. Share the Story: Because of the relationships that you built, you can build pivot tables with any of the fields from all three tables. H Purchase_Order_ID - Purchase_Order Date Purchase_Employee ID Suppller ID Raw Materlals Code Quantity Purchased Raw Materlal Purchase Price 20500 11/1/19 1009 3 1001 3 19,99 20501 11/5/19 11/10/19 1009 2 1003 10 29 20502 1009 1003 29 20503 11/13/19 1008 1 1002 12 44.99 20504 11/16/19 1009 1001 4 19.99 11/19/19 11/23/19 11/23/19 11/26/19 11/29/19 20505 1008 2 1001 12 19.99 20506 1009 1 1001 5 19.99 20506 1009 1 1003 29 20507 1009 1 1001 19.99 20508 1009 3 1 1001 4 19.99 12/4/19 12/9/19 20509 1009 1 1001 12 19.99 20510 1009 2 1001 11 19.99 12/12/19 12/16/19 12/19/19 20511 1008 3 1003 6 29 20512 1009 3 1001 7 19.99 20513 1008 1002 11 44.99 20514 12/24/19 1009 3. 1002 11 44.99 20515 12/28/19 1009 1 1002 4 44.99 20516 1/2/20 1008 1 1003 11 29 20517 1/5/20 1009 2 1001 10 19.99 20518 1/9/20 1009 1 1003 12 29 20519 1/14/20 1008 2 1001 1 19.99 20520 1/18/20 1008 1 1003 12 29 20521 1/23/20 1008 3 1001 6 19.99 20522 1/26/20 1009 3 1002 10 44.99 20523 1/31/20 1009 1 1001 8. 19.99 20524 2/4/20 1009 2 1001 1 19.99 20525 2/8/20 1008 3 1002 5 44.99 2/8/20 2/8/20 20525 1009 1002 2 44.99 20525 1008 3 1003 6 29 20526 2/13/20 1009 2 1001 11 19.99 20527 2/16/20 1009 2 1001 12 19.99 20527 2/16/20 1009 2 1003 6 29 20528 2/21/20 1008 1 1001 3 19.99 20529 2/24/20 1008 3 1003 10 29 2/28/20 2/28/20 20530 1008 3 1001 2 19.99 20530 1009 3 1003 2 29 20531 3/4/20 1008 3 1003 29 20532 3/7/20 1008 1 1002 2 44.99 20533 3/12/20 1009 1 1002 12 44.99 3/15/20 3/19/20 20534 1008 2 1002 5 44.99 20535 1009 3 1002 44.99 3/23/20 3/27/20 20536 1009 2 1001 12 19.99 20537 1008 1003 6. 29 3/31/20 4/4/20 20538 1009 1 1002 5 44.99 20539 1008 3 1003 29 20540 4/8/20 1008 2 1001 3 19.99 20541 4/11/20 1009 3 1003 10 29 20541 4/11/20 1008 3 1003 3 29 20542 4/14/20 1009 1 1003 29 20542 4/14/20 1009 1 1002 44.99 20543 4/18/20 1009 1 1002 1 44.99 20544 4/21/20 1008 2 1002 44.99 Required: 1. What is the Foreign Key in the Purchase_Orders table that allows you to relate it to the Suppliers table? O Customer_ID O Employee_ID O Purchase_Order_ID O Supplier_ID 2. What is the Foreign Key in the Purchase_Orders table that allows you to relate it to the Raw_Materials table? O Customer_ID O Raw_Materials_Code O Supplier_ID O Purchase_Order_ID 3. How many Purchase Orders for Hops were created for suppliers in Arkansas? O 52 O 5 O 4 8 0 4. How many Purchase Orders were created for suppliers in Arkansas (for any products)? O 18 O 5 O 52 O8 5. Change the PivotTable so that you see the sum of quantity purchased associated with each product and state. What was the quantity of hops purchased from suppliers in Minnesota? 28 42 344 50
Expert Answer:
Answer rating: 100% (QA)
Answers to the questions 1 Supplier ID 2Raw material code 3 8 ... View the full answer
Related Book For 
Advanced Accounting
ISBN: 978-0538480284
11th edition
Authors: Paul M. Fischer, William J. Tayler, Rita H. Cheng
Posted Date:
Students also viewed these accounting questions
-
Place a check mark in the column that indicates the location of each item that would be found on a bank reconciliation. Assume that the checks written by the company are writtencorrectly. Subtract...
-
Create requirements and the ER diagram with several attributes for a scenario with an entity involved in a unary relationship.
-
Fields from a Light Bulb we can reasonably model a 75-W incandescent light-bulb as a sphere 6.0 cm in diameter. Typically, only about 5% of the energy goes to visible light me rest goes largely to...
-
Bob Bristol just called to congratulate you on your excellent work on the various assignments at CII.He now wants you to do some capacity analysis for Meghan Willoughby, the Chief Purser. Meghan is...
-
Repeat Exercise 3 using the Cubic Spline Algorithm. Repeat exercise 3
-
ABC Co. and XYZ Co. are identical firms in all respects except for their capital structure. ABC is all-equity financed with $600,000 in stock. XYZ uses both stock and perpetual debt; its stock is...
-
With reference to Exercise 10.32, find a large sample 99% confidence interval for the true difference of the proportions. Data From Exercise 10.32 10.32 Photolithography plays a central role in...
-
Based on Sonderman and Abrahamson (1985). In treating a brain tumor with radiation, physicians want the maximum amount of radiation possible to bombard the tissue containing the tumors. The...
-
Calculate the cost of debt. Calculate the cost of equity. Calculate the weight of debt and equity. Calculate the WACC. Table 4 Stock Info Amount Bond Info Amount Shares Outstanding 100 Face value...
-
Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a dozen they cost $.40 each. Beverly earns a commission based on her...
-
2 cos x+cosx-1=0 Algebraically determine the value of x, where 540 x 720, for the following equation.
-
Rick Hall owns a card shop, Hall ? s Cards. The following cash information is available for the month of August, Year 3 . As of August 3 1 , ?the bank statement shows a balance of $ 1 2 , 4 6 0 ....
-
Provide a well-written essay of approximately 200 words. There are many ways in which this video relates to topics that we have covered in class. This chapter's focus is fiscal stimulus, but there...
-
A confectionery factory uses imported cocoa beans to make small chocolate bars. Randomly chosen chocolate bars are tasted and given a taste quality score; a numerical value ranging from 0 to 10....
-
If 7.83 g of Al react according to the given equation, how many moles of H2 would be produced? [MMAI = 26.98 g/mol] Equation: 6 HCI + 2 AI ---> 2 AICI 3 + 3 H
-
Examine the different modes of market entry for an organisation using appropriate examples.
-
A school uses an algorithm that returns a list of GPAs for all students. A programmer wants to use this algorithm to create a new one that will only return students with a GPA above 3.5, so the...
-
Define the essential properties of the following types of operating systems: a. Batch b. Interactive c. Time sharing d. Real time e. Network f. Parallel g. Distributed h. Clustered i. Handheld
-
On December 31, 2011, Adam Company purchases 100% of the common stock of Sampson Company for $475,000 cash. On this date, any excess of cost over book value is attributed to accounts with fair values...
-
Select the best answer for each of the following multiple-choice questions: 1. AVHWO receives a donation that is restricted to its endowment and another donation that is restricted to use in...
-
The following nominal accounts were extracted from the December 31, 2018, adjusted trial balance of Landmark Private Hospital: Required Prepare a statement of activities for the year ended December...
-
a. Assume that \(y_{1}, \ldots, y_{n}\) are i.i.d. with a negative binomial distribution with parameters \(r\) and \(p\). Determine the maximum likelihood estimators. b. Use the sampling mechanism in...
-
For the data in Table 12.1, confirm that the Pearson statistic in equation (12.3) is 41.98 . Table 12.1 (12.3) Count Observed (j) (nj) Fitted Counts Using the Poisson Distribution (np;) 01234 6,996...
-
Show that the log-likelihood in equation (12.2) has a maximum at \(\widehat{\mu}=\bar{y}\). n L() Inf(y,) = (-+y; In - In y;!). i=1 i=1 (12.2)
Study smarter with the SolutionInn App