Transcribed Image Text
Prototyping an Event-Driven IT Application DC Medical Supply,located in Washington, DC is in the industry of medical devicesales. Its market share is small compared to the industry leaders,but it hopes to increase its share by becoming more responsive tocustomer needs. DC Medical Supply would like your help documentingtheir sales process using an event driven ERP. The following is adescription of the sales/collection process of DC Medical Supply.When customers need to order medical devices, they place an orderonline at DCMedicalSupply.com. When orders are received, a salesrepresentative records the order to update the Sales OrderTransaction file and prints two copies of a formal sales order andone copy of a stock release document. The sales representativestaples one copy of the sales order to the stock release and sendsit to the warehouse department. The other copy of the sales orderis filed numerically in the sales department. If part of an orderis out of stock, it will be picked when it is available. Awarehouse employee receives the stock release and sales order andpicks and scans the goods using a handheld scanner to update thePick Transaction file. The warehouse employee forwards the goods,the stock release and order document to the shipping department. Ashipping clerk proceeds to update the Shipment Transaction file andprints the packing list and three copies of the shipping notice.The shipping companies arrive every day at 4:30 PM, and a shippingclerk gives them the packing slip, the original shipping notice andthe devices to be shipped. The stock release, a copy of theshipping notice, and the sales order are stapled together and sentto the billing department. The last copy of the shipping notice isfiled numerically in Shipping. The Billing Department receives theorder, stock release and shipping notice, prepares the invoice,emails it to the customer and saves an electronic copy of it in thedepartment. Once the invoice has been sent, a billing clerk sendsthe sales order, stock release, and shipping notice to the accountsreceivable department. At the end of each month, the accountsreceivable department emails customers with balances owing. DCMedical Supply accepts installment payments in some cases. The cashreceipts clerk receives the checks and updates the cash receiptstransaction file. The controller prepares a deposit slip anddeposits the checks at the local bank branch. Customers have 30days to return devices to DC Medical Supply warehouse. Required:(Turn in two pieces of paper, unstapled, with your name on the topof each page.) 1. Conceptual model: Draw an REA model withcardinalities for the operating events in the sales/collectionprocess described above (do not model the production of the bakeditems). Make sure you differentiate between the operating and theinformation events. The REA model can be hand-drawn, but neatnessis required. 2. Logical model: List each database table required(master and event tables), complete with key attributes (primarykeys), foreign keys, and non-key attributes. Use proper notation asdescribed in class. This part of the requirement needs to betypewritten.
Other questions asked by students
Angela has not been making as many sales as her co-workers. Michael decides she needs...
Find the area of the parallelogram with vertices A 1 1 4 B 0 3...
Setup an integral to find the surface area of a sphere of radius 1 using...
Suppose that the functions fand g are defined as follows f x 4x 5 g...
For the Months of December and January December January Cash sales Collection of credit sales:...
A long hedge is a risk management strategy in which a company can lock in...