Consider the following portion of an EER diagram of revenue business processes RETURNS AND ALLOWANCES SALES...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following portion of an EER diagram of revenue business processes RETURNS AND ALLOWANCES SALES have have RETURNED MERCHANDISE The EER diagram presented above is based on the assumption that returns and allowances are have none or many returns and allowances. Each "return and allowance" could have either none treated similarly and can therefore be grouped together in one entity. A "sale" instance could (in the case of allowances) or many "returned merchandise" instances. A "returned merchandise" item relates to at least one but possibly many different returns. Assume that the company wants to record returns and allowances separately. Furthermore, there could be several returns associated with a given sale, but only one allowance associated with a sale. Each return would have at least one returned merchandise item, but possibly many returned items. A returned merchandise item would relate to at least one but possibly many returns. How would you modify the EER diagram to accommodate these changes,?A) Draw the new EER diagram B)Show the tables that would result from your modified EER diagram (you can show only the primary and Foreign keys). Consider the following portion of an EER diagram of revenue business processes RETURNS AND ALLOWANCES SALES have have RETURNED MERCHANDISE The EER diagram presented above is based on the assumption that returns and allowances are have none or many returns and allowances. Each "return and allowance" could have either none treated similarly and can therefore be grouped together in one entity. A "sale" instance could (in the case of allowances) or many "returned merchandise" instances. A "returned merchandise" item relates to at least one but possibly many different returns. Assume that the company wants to record returns and allowances separately. Furthermore, there could be several returns associated with a given sale, but only one allowance associated with a sale. Each return would have at least one returned merchandise item, but possibly many returned items. A returned merchandise item would relate to at least one but possibly many returns. How would you modify the EER diagram to accommodate these changes,?A) Draw the new EER diagram B)Show the tables that would result from your modified EER diagram (you can show only the primary and Foreign keys).
Expert Answer:
Answer rating: 100% (QA)
Based on the revised requirements the modified EER diagram would look like this SALES RETURNS AND AL... View the full answer
Related Book For
Financial Accounting
ISBN: 978-1259103285
5th Canadian edition
Authors: Robert Libby, Patricia Libby, Daniel Short, George Kanaan, M
Posted Date:
Students also viewed these accounting questions
-
The LRU replacement policy is based on the assumption that if address A1 is accessed less recently than address A2 in the past, then A2 will be accessed again before A1 in the future. Hence, A2 is...
-
Eq. (12.2.4) is based on the assumption that Z has approximately a normal distribution. Occasionally, the normal approximation is not good enough. In such cases, one can let v = 2/2(1 ). (12.2.6) To...
-
1 a. Intrusion detection is based on the assumption that the behavior of the intruder differs from that of a legitimate user in ways that can be quantified. Of course, we cannot expect that there...
-
Assume that Jimmy Cash has $2000 in his checking account at Folsom Bank and uses his checking account card to withdraw $200 of cash from the banks ATM machine. By what dollar amount did the M1 money...
-
The following items are available from records of Freescia Corporation at the end of the 2010 calendar year: Required Prepare a balance sheet. Accounts payable Accounts receivable Advertising expense...
-
1. Prepare the balance sheet for Wilson Towing Service as of June 30,2014. 2. What does the balance sheet report? Equipment Office Supplies Notes Payable Rent Expense Cash Wilson, Withdrawas 11,200...
-
Rework Problem 4.34 if the phase spacing is: (a) increased by \($20\) % \($\) to \($4.8\) \mathrm{ft}\($\), (b) decreased by \($20\) % \($\) to \($3.2\) \mathrm{ft}\($\). Compare the results with...
-
Presented below is information related to Taylor Co. for the month of January 2014. Instructions (a) Prepare the necessary adjusting entry for inventory. (b) Prepare the necessary closingentries....
-
Start from the bottom. The ones in red need solving. Thank you. On April 1, Larkspur, Inc. was established. These transactions were completed during the month. 1. Stockholders invested $29,600 cash...
-
You are the senior acquisitions associate at a New York-based private equity fund with a core investment focus. You have reached an agreement to purchase a well-located, 185,000 square foot office...
-
Draw the y(t) signal if the signal x(t) shown below: 1. y(t) = x(t - 4) 2. y(t) = x(t + 2) x(4) 3. y(t) = 3x(-t) 4. y(t) = x(-t + 3) 5. y(t) = x( t/2 1) 6. y(t) = x( 3t + 4 ) 7. y(t) = x(t) u(t) %3D...
-
discuss the recent advancements in chromosome conformation capture techniques, such as Hi-C and 3C-based methods, and their contributions to our understanding of chromosomal architecture, genome...
-
GTA Bowling has 72 million shares outstanding, with a current share price of $10.73 per share. If the firm's book value of equity is $207.12 million, what is its market-to- book ratio?
-
The value of a 37% interest in Take'm or Leave'm Corp. was $675,000 before discounts and premiums. Using Mergerstat data the control premium was 34%. In addition the applicable marketability discount...
-
Omega Corporation uses breakeven analysis to study the effects of expansion projects it considers. Currently, the firm's plastic bag business segment has fixed costs of P120,000, while its unit price...
-
What does a change in the reported unit cost of a particular productimply about the economic costs of that product? Also, identify one specific condition when a change in the reported unit cost of a...
-
A researcher is interested in studying the effects of ambient sounds to help Grade 2 students focus on their school activities. They have all Grade 2 students from a local elementary school listen to...
-
White Bolder Investments (WBI) You are an intern working for WBI, a large investment advisory services in Sydney. Among other regular customers, WBI has been providing advisory services for Jumbo...
-
The comparative statements of financial position for Marwa Ld. at December 31, 2015 and 2014, are presented below: The statement of earnings for 2015 showed the following information: Sales...
-
Betsey Jordan asked a local bank for a $ 50,000 loan to expand her small company. The bank asked Betsey to submit a financial statement of the business to supplement the loan application. Betsey...
-
Distinguish between depreciation and depletion.
-
Search the Internet: Is plagiarism fraud?
-
Search the Internet and learn about the AICPA's site on Business Valuation and Forensic/Litigation Services.
-
Go to the Journal of Forensic Accounting Inter- net site. What approach does the publisher, James Edwards, take with respect to the defi- nition of forensic accounting? Is the narrow or broad...
Study smarter with the SolutionInn App