Answered step by step
Verified Expert Solution
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started