Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need just 4 and 5 requierment Martin Shoes, Inc. manufactures and distributes orthopedic footwear. To sell its products, the marketing department requires sales personnel

image text in transcribed

image text in transcribed

i need just 4 and 5 requierment

Martin Shoes, Inc. manufactures and distributes orthopedic footwear. To sell its products, the marketing department requires sales personnel to call on the shoe retailers within their assigned geographic territories. Each salesperson has a laptop computer, which he or she uses to record sales orders during day and to send these sales orders to Martin's network nightly for updating the company's sales order file. Each day, warehouse personnel review the current sales orders in its file, and where possible, pick the goods and ready them for shipment. (Martin ships goods via common carrier, and shipping terms are generally FOB from the shipping point.) When the shipping department completes a shipment, it also notifies the billing department, which then prepares 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 the customer's account and records the cash received. Requirements 1. Identify the resources, events, and agents within Martin's revenue process. 2. Develop an E-R diagram for this process that illustrate the relationships between these items. 3. Use Microsoft Access to create any three tables illustrated in E- R diagram.( Select the data type for each field, Create data validation rules, use the input mask). 4.Using Access, create at least three records for each of the tables 5. Link the tables together. Be sure to check "enforce referential integrity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Analysis Microsoft Excel 2010

Authors: Conrad Carlberg

1st Edition

0789747200, 9780789747204

More Books

Students also viewed these Accounting questions

Question

3. Use the childs name.

Answered: 1 week ago