Homework Help: Accounting

Posted by Leigh on Thursday, July 2, 2009 at 2:30am.

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?

Accounting - SraJMcGin, Thursday, July 2, 2009 at 2:50am
This is definitely not my area, but hopefully the following will have some things to help you:

http://www.google.com/search?q=accounting+E-R+diagram+%26+DBMS+tables&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Other than that, ther are some excellent Accounting Tutorials out there:

http://www.google.com/search?q=Accounting+Tutorials&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Sra

Answer this Question

Related Questions

Business - I need to describe my product. I have a pretend shoe business that I ...
economics. urgent - Assuming that shoes have a world price of US$60 a pair, that...
5th grade math - Pete looked at the colors of the shoes worn by his classmates. ...
Math - The clothing stor had a sale for 75% off most of its shoes.Malik ...
statistics - The abc shoe factory manufactures shoes 24 hours a day. the workers...
Lang. Arts - Of the following things that Martin says or does, which best ...
English - I forgot to include the following list of words. Can you just tell me ...
algebra - Tod paid $81.22 for a pair of shoes during a 30% off sale. What was ...
Math - A shoe company will make a new type of running shoe. The fixed cost for ...
Calc BC - A shoe company will make a new type of running shoe. The fixed cost ...

For Further Reading

First Name:
School Subject:
Answer: