Prototyping an Event-Driven IT Application DC Medical Supply, located in Washington, DC is in the industry...

90.2K

Verified Solution

Question

Accounting

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.

Answer & Explanation Solved by verified expert
4.5 Ratings (941 Votes)
SALES PROCESS Conceptual model Logical model Customer Trigger Trigger Online order is placed at Dcmedicalsupplycom Sales Representative Operating event Master Table Update sales order transaction file SOTF print two copy of sales order and one copy of stock release document Informational event Event table Sends one copy of Sales order and stock release doc to warehouse dept Informational event Event table Another copy of Sales order is kept with Sales Dept for    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

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