Question: Problem 3 (15 points) r. Rapha Consider the following REA segment of revenue business processes. 489 21714149 Lel 22400489 Sales BO Returned Items PC Take

Problem 3 (15 points) r. Rapha Consider the following REA segment of revenue business processes. 489 21714149 Lel 22400489 Sales BO Returned Items PC Take Retums 120 The REA segment presented above is based on the assumption that "Take Returns" and "Give Allowances " activities are treated similarly and therefore are grouped together in one entity (i.e., *Take Returns" event). It also assumes that a sale may not be associated with a return, but can be associated with many returns. Each return must be associated with only one sale. In addition, each return may not be related to a returned item (i.e., "Returned Items" resource), but can be related to many returned items. Assume that the company wants to record "Take Returns" event and "Give Allowances" event separately. Furthermore, each return must be associated with only one sale, but there can be several returns related to a given sale. Similarly, each allowance must be related to only one sale, but there can be several allowances related to a given sale. In addition, each return must have one but possibly many returned items. A returned item must be related to one but possibly many returns. Required: phael 49 Raphael 20 149 Design a modified REA segment to accommodate the changes. Also, complete the following relational database table that would result from your modified REA segment. For each table, provide at least TWO relevant attributes. a) Modified REA Segment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
