Part I1. PROBLEMS 1. Consider the following portion of an EER diagram of revenue RETURNED MERCHANDISE SALES have RETURNS AND have The EER diagram presented above is based on the erchandialowae.her in one entity. A "sale" instance could (in the case of allowances) or many "returned merchandise" item relates to at least one but possibly many Assume that treated similarly and can therefore be grouped together aance" assumption that returns and allowances are or many returns and allowances. Each "return and allowance "returned instances. A could be several returns associated with a given sale, but onlyt possibly sale. Each the company wants to record returns and allowances separately return would have at least one returmed merchandise item, but possion a given sale, but one allowance associated with a items. A returned merchandise item would relate to at least one returns. but possibly many How would you modify the EER diagram to accommodate these changes,?A) Draw new EER can show dhagram B)Show the tables that would result from your modified EER diagram you cas only the primary and Forcign keys). Part I1. PROBLEMS 1. Consider the following portion of an EER diagram of revenue RETURNED MERCHANDISE SALES have RETURNS AND have The EER diagram presented above is based on the erchandialowae.her in one entity. A "sale" instance could (in the case of allowances) or many "returned merchandise" item relates to at least one but possibly many Assume that treated similarly and can therefore be grouped together aance" assumption that returns and allowances are or many returns and allowances. Each "return and allowance "returned instances. A could be several returns associated with a given sale, but onlyt possibly sale. Each the company wants to record returns and allowances separately return would have at least one returmed merchandise item, but possion a given sale, but one allowance associated with a items. A returned merchandise item would relate to at least one returns. but possibly many How would you modify the EER diagram to accommodate these changes,?A) Draw new EER can show dhagram B)Show the tables that would result from your modified EER diagram you cas only the primary and Forcign keys)