Question

REA model for customer art seller - acquisition/payment

Complete an REA model with minimum and maximum cardinalities of the process (transaction cycle) you will be prototyping for the System Project. 1. Make up a company within your industry. 2. Model one complete transaction cycle REA model with cardinalities. 3. Identify the 2 related events you want to choose for your system project. These 2 events must be connected by a relationship line. a. This can be handwritten, although your final project will require this to be completed using a computer application. Your REA model for this assignment and your final project should include your complete transaction cycle. However, your final project and assignment 4 require you to only prototype (build in Access) your 2 chosen events (and related agents & resources). 4. Design at least one *:* relationship with an event-resource in your REA model. 5. Keep graded Step 1 in paper form, you will need it for step 2.

Answer 1

1. Make up a company within your industry.

Industry: Retail

Segment: Art

Company: Sue’s gallery

2. Model one complete transaction cycle REA model with cardinalities.

Order inquiries Customer Goods Art Seller Payment Receipt

3. Identify the 2 related events you want to choose for your system project. These 2 events must be connected by a relationship line.

Event 1: Herein the customer want to present the Art as a gift to the third person, so he/she is requesting to deliver the art to the third person, whereas the payment will be given by the customer.

Order Inquiry Customer 1.Sales Order Payment Receipt Collection Order details 2 Prepare goods Goods delivered 3.Cash Collection Sales Details Third Person Kecoding in database

Event 2: Herein the good is sold via sales agent, wherein the

1. The order is obtained from customer later transmitted to sales order area.
2. As per the order details goods are processed and send to the customer.
3. The customer makes payment to the sales agent, which is transmitted to the cash collection counter and recorded.

Order Inquiry Sales Agent 1.Sales Order Order Inquiry Receipt Goods Order details 2.Prepare Payment goods Customer Collection 3 Cash Collection Sales Details Recoding in database