REA Assignment Key Spring 2009

REA Assignment Key Spring 2009 - INVENTORY: Item # ,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Deliver Goods to Customer Pick Stock Items Receive Customer Order Telephone Operator Customer Credit Manager Shipping Clerk Inventory Items Receive Payment Cash A/R Clerk (0,*) (1,*) (0,*) Accept Return (1,*) (1,*) (1,*) (0,*) (0,*) (0,*) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (1,1) (0,*) (0,*) (1,1) (1,1) (0,*) (0,1) (1,1) (1,*) (0,1) Warehouse Clerk (0,*) (1,1) (1,1) ACCT-361 – Fall 2008 Solution to Assignment #6 - Business Process Modeling It is perfectly o.k. to model the credit approval separately. In the above design, I collapsed the credit approval and order events. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Master/Maintenance Tables: TEL OPERATOR: Operator # , Name, Street Address, City, State, Zip, Telephone#, etc. . . CUSTOMER: Customer # , Name, Street Address, City, State, Zip, Telephone#, Credit Limit, etc. . CREDIT MANAGER: Manager # , Name, Street Address, City, State, Zip, Telephone#, etc. . . SHIPPING CLERK: Shipping Clerk # , Name, Street Address, City, State, Zip, Telephone#, etc. . . AR CLERK: AR Clerk # , Name, Street Address, City, State, Zip, Telephone#, Birth Date , etc. . .
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: INVENTORY: Item # , Description, Current Price, Standard Cost, BQOH, BQOH Date CASH: Cash Account # , Bank, Type of Account, BegBalance, BegBalance Date Event/Transaction Tables: ORDER: Order # , [Customer #], [Operator #], [Credit Mgr #], Date ORDER-INVENTORY: [Order # ], [Item # ], Qty Ordered, Lead Time Promised PICK: Pick # , [Warehouse Clerk #], [Order #], Date PICK-INVENTORY: [Pick # ], [Item # ], Qty Picked DELIVER: Sale # , [Pick #], [Shipping Clerk #], [Customer #], Date DELIVER-INVENTORY: [Sale # ], [Item # ], Qty Shipped RECEIPT: Cash Receipt # , [Customer], [AR Clerk #], [Cash Account #], Amount, Document Type, Document #, Date RECEIPT-DELIVER: [Cash Receipt # ], [Sale # ], Amount Applied RETURN: Sale Return # , [Customer #], [Shipping Clerk #], [Sale #], Date RETURN-INVENTORY: [Sale Return # ], [Item # ], Qty Returned 2...
View Full Document

Page1 / 2

REA Assignment Key Spring 2009 - INVENTORY: Item # ,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online