Accounting

posted by .

13-22

Martin Shoes, Inc. (Planning a Database Using REA and 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 within their assigned geographic territories. Each salesperson has a laptop computer, which he or she uses to record sales orders during the day and to send these sales order to Martin's network nightly for updating the company's sales order file.

Each day, warehouse personnel review the current sales order in its file, and where possible, pick the good 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 the 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.

3. With a particular DBMS is mind, design the tables for this revenue process. Note that you will need tables for each resource, event, and agent, as well as tables for each many-to-many relationship.

This has me utterly confused. I even read the chapters and still haven't been able to figure it out. Someone help?

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Business

    I need to describe my product. I have a pretend shoe business that I to do for my business class. What exactly I need to do is to describe my product which is shoes. I sell for all seasons, all styles, all prices and everyone. I need …
  2. marketing

    you work in the marketing department of a small sportswear and accessories, but a proposal to diversify into sports shoes is under consideration. your marketing director asks you to write a report on the advantages and disadvantages …
  3. Managerial Accounting

    The Fashion Shoe Company operates a chain of women’s shoe shops around the country. The shops carry many styles of shoes that are all sold at the same price. Sales personnel in the shops are paid a substantial commission on each …
  4. Calc BC

    A shoe company will make a new type of running shoe. The fixed cost for the production will be $54,000. The marginal cost will be $25 per pair of shoes. The shoes will sell for $115 for each pair. a) Write the cost function b) Write …
  5. Calc BC

    A shoe company will make a new type of running shoe. The fixed cost for the production will be $54,000. The marginal cost will be $25 per pair of shoes. The shoes will sell for $115 for each pair. a) Write the cost function b) Write …
  6. Math

    A shoe company will make a new type of running shoe. The fixed cost for the production will be $54,000. The marginal cost will be $25 per pair of shoes. The shoes will sell for $115 for each pair. a) Write the cost function b) Write …
  7. Principles of Business

    Approximately how many people work in the: Finance Department?
  8. statistics

    The abc shoe factory manufactures shoes 24 hours a day. the workers produce 50,000 shoes every 2.3 days How many hours does it take to produce 50,000 shoes
  9. math

    A men's shoe store uses a markup rate of 115% on its most popular brands of shoes. If the shoe store buys a pair of popular-brand shoes for a wholesale price of $79, what will be the retail price of the shoes, to the nearest cent?
  10. Math

    There are four brown shoes and 10 black shoes on the floor. your puppy cares away two shoes and puts one shoe in the trashcan and one in the laundry basket. a. What is the probability that there will be a black shoe in the trash and …

More Similar Questions