Consider the following portion of an EER diagram of revenue business processes RETURNS AND ALLOWANCES SALES...

 

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

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