SuperTutor

(15)

$15/per page/Negotiable

About SuperTutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Business & Finance See all
Accounting,Business & Finance,Economics,Engineering,HR Management,Math Hide all
Teaching Since: Apr 2017
Last Sign in: 234 Weeks Ago, 1 Day Ago
Questions Answered: 12843
Tutorials Posted: 12834

Education

  • MBA, Ph.D in Management
    Harvard university
    Feb-1997 - Aug-2003

Experience

  • Professor
    Strayer University
    Jan-2007 - Present

Category > Accounting Posted 20 Jun 2017 My Price 7.00

  Ian's Place (The REA Model and E-R Diagrams)

My portion of the assignment is question #2. Can someone help me with this please?

 

 

7-20.  Ian's Place (The REA Model and E-R Diagrams)

Ian's place sells pet supplies to dog and cat owners. To sell its products, the marketing department requires sales personnel to call on the pet store retailers within their assigned geographic territories. Salespeople have an application on their mobile phones that allows them to record sales orders and send these sales orders directly to the company network 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. (Ian's Place 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 involved in the revenue process at Ian's Place.
  2. Develop an E-R diagram for this process.
  3. 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.

Answers

SuperTutor
(15)
Status NEW Posted 20 Jun 2017 01:06 AM My Price 7.00

-----------

Attachments

file 1497922064-Solutions file.docx preview (56 words )
S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------on-----------th-----------is -----------web-----------sit-----------e. ----------- H-----------YPE-----------RLI-----------NK -----------&qu-----------ot;-----------htt-----------p:/-----------/wo-----------rkb-----------ank-----------247-----------.co-----------m/&-----------quo-----------t; -----------\t -----------&qu-----------ot;-----------_bl-----------ank-----------&qu-----------ot;----------- -----------Tha-----------nk -----------you----------- -----------
Not Rated(0)