Question: Design a modified REA segment Consider the following REA segment of expenditure business processes. The REA segment presented above is based on the assumption that
Design a modified REA segment
Consider the following REA segment of expenditure business processes. The REA segment presented above is based on the assumption that "Return Items" and "Get Allowances" activities are treated similarly and therefore arc grouped together in one entity (i.e., "Return Items" event). It also assumes that a purchase may not be associated with a return, but can be associated with many returns Each return must be associated with only purchase. In addition each return may not be related to a received item. (i. e., "Received Items" resource), but can be related to many received items. Assume that the company wants to record ''Return Items" event and "Get Allowances" event separately. Furthermore, each return must be associated with only one purchase, but there can be several returns related to a given purchase. Similarly, each allowance must be related to only one purchase, but there can be several allowances related to a given purchase. In addition, each return must have one but possibly many received items. A received item must be related to one but possibly many returns. 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
