Using cardinalities shown in the partial ER diagram, name the Foreign Key(s) (FK) that should be...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using cardinalities shown in the partial ER diagram, name the Foreign Key(s) (FK) that should be placed into the respective tables. If no foreign key is required in a table, then indicate NONE. Add any table(s) and Keys that may be needed Customer Table Salesman Table (PK) Customer Num (PK) Salesman Num None None Cash Receipts Table Sales Order Table M M Inventory Table M. (PK) Cash Rec Num (PK) Invoice Num (PK) Part Number Customer Num (FK) Customer Num (FK) Salesman Num (FK) M 1 None Part Number (FK) M4 Supplier Table Link Table (PK) Vendor Num M (PK) Part Number (PK) Vendor Num None Using cardinalities shown in the partial ER diagram, name the Foreign Key(s) (FK) that should be placed into the respective tables. If no foreign key is required in a table, then indicate NONE. Add any table(s) and Keys that may be needed Customer Table Salesman Table (PK) Customer Num (PK) Salesman Num None None Cash Receipts Table Sales Order Table M M Inventory Table M. (PK) Cash Rec Num (PK) Invoice Num (PK) Part Number Customer Num (FK) Customer Num (FK) Salesman Num (FK) M 1 None Part Number (FK) M4 Supplier Table Link Table (PK) Vendor Num M (PK) Part Number (PK) Vendor Num None
Expert Answer:
Related Book For
Horngrens Financial and Managerial Accounting
ISBN: 978-0133866292
5th edition
Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these accounting questions
-
If a customer order is placed on May 1 and the company expects to begin processing it on May 10, and the order is shipped on May 20, the cycle time is then how many days long?
-
Marine Plywood : A customer has placed an order for 2 emergency dinghies that Ship Builders manufacture. However, Ship Builders currently has none in stock and therefore they must manufacture them....
-
A uniform sphere of radius r and mass m is placed with no initial velocity on a belt that moves to the right with a constant velocity v1. Denoting by k the coefficient of kinetic friction between the...
-
A social skills training program was implemented with seven mildly challenged students in a study to determine whether the program caused improvements in pre/post measures and behavior ratings. For...
-
Acme, Inc. has just completed a study of its production process for gadgets. It uses labor and capital to produce gadgets. It has determined that 1 more unit of labor would increase output by 200...
-
In a global economy, dealing with currencies, monetary amounts, conversions, rounding and formatting is complex. The new JavaMoney API was developed to meet these challenges. At the time of this...
-
Tests of the fidelity and the selectivity of 190 digital radio receivers produced the results shown in the following table: Use the 0.01 level of significance to test whether there is a relationship...
-
Peter owns 50% of Air South Corporation, an air charter service. His S corporation stock basis at beginning of the year is $100,000. Air South has not done well this year and will report an ordinary...
-
If a bank charges an interest rate of 0.6% per quarter on loans to its customers, what APR must this lender report to consumers? A bond with 10 years left to maturity currently sells for 105% of par...
-
Prepare a skeleton statement of revenues, expenditures, and changes in fund balances using the headings in Illustration 2-11 (e.g., Revenues, Expenditures, and Excess (Deficiency) of Revenues over...
-
Instructions write tw page memo for your tax partner. Your response should be in a format of a file memorandum (see outline below). You should include citations to the Internal Revenue Code (IRC)....
-
1) Suppose you have $20,000 in cash to invest. You decide to short sell $10,000 worth of Coca Cola stock and invest the proceeds from your short sale, plus your $20,000, in Intel. At the end of the...
-
What are the CCI Code Pair Edits and PTP modifiers for lab codes 85025, 80053, 87636, 85014?
-
At what velocity (in revolutions per minute) will the peak voltage of a generator be 490 V, if its 480 turn, 8.00 cm diameter coil rotates in a 0.250 T field? rpm +
-
How did Ptolemys atlas contribute to a greater understanding of world geography, and how did it produce confusion?
-
Drinking fountains that actively chill the water they serve cant work without ventilation. They usually have louvers on their sides so that air can flow through them. Why do they need this airflow?
-
Rey Company's only product sells for $235 per unit. Data for its first year of operations follow. Direct materials Direct labor Variable overhead Fixed overhead Variable selling and administrative...
-
d. The characteristic equation of a control system is given by s+2s+8s+12s+20s+16+16=0. Determine the number of the roots of the equation which lie on the imaginary axis of s-plane
-
Daily Corp. is considering the use of activity-based costing. The following information is provided for the production of two product lines: Daily plans to produce 200 units of Product A and 300...
-
This problem continues the Daniels Consulting situation from Problem P4-40 of Chapter 4. Daniels Consulting performs systems consulting. The company has also begun selling accounting software and...
-
Yates has $13,500 in cash on hand on January 1 and has collected the following budget data: Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally,...
-
The following is the trial balance of Sanjay Industries Ltd. as on 31st March 2006. Further information 1.Outstanding rent amounted to 7,200 while outstanding salaries 8,100 at the end of the year....
-
Refer to the case of Monik Traders given in the exercises of the last chapter. Monik Varma now wants to know as to where his firm stands after one month of running of the business. Help him. Towards...
-
The accountant of Pushpa Engineering Company Ltd. has prepared the following trial balance of the company as on 31st March, 2006. Further information 1. Authorised equity share capital of the company...
Study smarter with the SolutionInn App