Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following portion of an EER diagram of revenue business processes RETURNS AND ALLOWANCES SALES have have RETURNED MERCHANDISE The EER diagram presented

 

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).

Step by Step Solution

3.46 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

Based on the revised requirements the modified EER diagram would look like this SALES RETURNS AND AL... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Libby, Patricia Libby, Daniel Short, George Kanaan, M

5th Canadian edition

9781259105692, 978-1259103285

More Books

Students also viewed these Accounting questions

Question

What are the parameters in a simple linear regression model?

Answered: 1 week ago

Question

Distinguish between depreciation and depletion.

Answered: 1 week ago