Question;ACC340week4chapter13-22 racennAbbottChapter 13: Case Analyses 13?22 (Martin Shoes, Inc.)Complete the University of Phoenix Material: Database Definitions Exercise located on the student website.13-22. Martin Shoes, Inc. (Planning a Database Using REAand E-R Methodology)Martin Shoes, Inc., manufactures and distributes orthopedic footwear. To sell its products,the marketing department requires sales personnel to call on the shoe retailers withintheir assigned geographic territories. Each salesperson has a laptop computer, which heor she uses to record sales orders during the day and to send these sales orders to Martin?snetwork nightly for updating the company?s sales order file.Each day, warehouse personnel review the current sales orders in its file, and wherepossible, pick the goods and ready them for shipment. (Martin ships goods via commoncarrier, and shipping terms are generally FOB from the shipping point.) When the shippingdepartment completes a shipment, it also notifies the billing department, which thenprepares an invoice for the customer. Payment terms vary by customer, but most are??net 30.?? When the billing department receives a payment, the billing clerk credits thecustomer?s account and records the cash received.Requirements1. Identify the resources, events, and agents within Martin?s revenue process.2. Develop an E-R diagram for this process.3. With a particular DBMS in mind, design the tables for this revenue process. Note thatyou will need tables for each resource, event, and agent, as well as tables for eachmany-to-many relationship.
Paper#43665 | Written in 18-Jul-2015Price : $28