Question
DC Medical Supply, located in Washington, DC is in the industry of medical device sales. Its market share is small compared to the industry leaders,
DC Medical Supply, located in Washington, DC is in the industry of medical device sales. Its market share is small compared to the industry leaders, but it hopes to increase its share by becoming more responsive to customer needs. DC Medical Supply would like your help documenting their sales process using an event driven ERP. The following is a description of the sales/collection process of DC Medical Supply. When customers need to order medical devices, they place an order online at DCMedicalSupply.com. When orders are received, a sales representative records the order to update the Sales Order Transaction file and prints two copies of a formal sales order and one copy of a stock release document. The sales representative staples one copy of the sales order to the stock release and sends it to the warehouse department. The other copy of the sales order is filed numerically in the sales department. If part of an order is out of stock, it will be picked when it is available. A warehouse employee receives the stock release and sales order and picks and scans the goods using a handheld scanner to update the Pick Transaction file. The warehouse employee forwards the goods, the stock release and order document to the shipping department. A shipping clerk proceeds to update the Shipment Transaction file and prints the packing list and three copies of the shipping notice. The shipping companies arrive every day at 4:30 PM, and a shipping clerk gives them the packing slip, the original shipping notice and the devices to be shipped. The stock release, a copy of the shipping notice, and the sales order are stapled together and sent to the billing department. The last copy of the shipping notice is filed numerically in Shipping. The Billing Department receives the order, stock release and shipping notice, prepares the invoice, emails it to the customer and saves an electronic copy of it in the department. Once the invoice has been sent, a billing clerk sends the sales order, stock release, and shipping notice to the accounts receivable department. At the end of each month, the accounts receivable department emails customers with balances owing. DC Medical Supply accepts installment payments in some cases. The cash receipts clerk receives the checks and updates the cash receipts transaction file. The controller prepares a deposit slip and deposits the checks at the local bank branch. Customers have 30 days to return devices to DC Medical Supply warehouse. Required: (Turn in two pieces of paper, unstapled, with your name on the top of each page.) 1. Conceptual model: Draw an REA model with cardinalities for the operating events in the sales/collection process described above (do not model the production of the baked items). Make sure you differentiate between the operating and the information events. The REA model can be hand-drawn, but neatness is required. 2. Logical model: List each database table required (master and event tables), complete with key attributes (primary keys), foreign keys, and non-key attributes. Use proper notation as described in class. This part of the requirement needs to be typewritten.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started