Preview

Week 4 Assignments From The Reading

Satisfactory Essays
Open Document
Open Document
422 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Week 4 Assignments From The Reading
Assignments from the Reading
Week 4

Neal Hennessy

Case Analysis 13-22
1. Identify the resources, events, and agents within Martin's revenue process.
Resources: Cash, Inventory
Events: Sale of Goods/Customer Order, Shipment of Goods, Receive Payment/Cash Collections
Agents: Salesperson, Customer, Shipping Clerk, Billing Clerk
2. Develop an E-R diagram for this process.

3. With a particular DBMS in 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.
Inventory Table

Item Number
Item Description
Item Cost
Beginning Inventory
1001
Business Shoe
$12.13
1192
1002
Running Shoe
$9.84
1941
1003
Shoe Insert
$3.29
734
1004
Multipurpose Sock
$2.14
958

Cash Table

Invoice Number
Invoice date
Amount Paid

A101
1/3/2015
$207.44

A102
1/9/2015
$292.31

A103
1/11/2015
$81.80

A104
1/16/2015
$547.70

Sales Table

Order Number
Employee Number
Customer Number
Order Value
2100
AB21
12A
$207.44
2200
DH40
13A
$292.31
2300
AB21
12A
$81.80
2400
RN19
12B
$547.70

Shipping Table

Order Number
Destination State
Ship Date
Tracking Number
2100
WA
1/6/2015
IZE236578
2200
CA
1/11/2015
IZE603982
2300
MT
1/11/2015
IZE228011
2400
NY
1/17/2015
IZE382168

Receipt of Payment Table

Invoice Number
Invoice Date
Date Paid

A101
1/3/2015
2/1/2015

A102
1/9/2015
2/7/2015

A103
1/11/2015
2/2/2015

A104
1/16/2015
2/9/2015

Salesperson Table

Employee Number
Employee Name
Contact Number
DOH
AB21
Aaron Brown
509-123-4567
3/4/1997
RN19
Rochelle Nelson
509-234-5678
6/21/2011
BK73
Brian King
509-345-6789
11/14/2010
DH40
David Harper
509-456-7890
7/9/2013

Customer Table

Customer Number
Customer Name
State
Credit Limit
12A
Foot World
509-567-8901
$5,000
13A
Runners United
509-678-9012
$7,500
14A
Footwear Depot
509-789-0123
$3,000
12B
Feet 4 All
509-890-1234
$8,000

Shipping Clerk Table

Employee Number
Employee Name
Contact Number
DOH
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Powerful Essays

    Ch 13 Study Questions Spring 2014
    • 1640 Words
    • 10 Pages

    Ch 13 Study Questions Spring 2014

    17) Tests both upper and lower motor pathways. The sole of the foot is stimulated with a dull instrument.…

    • 1640 Words
    • 10 Pages
    Powerful Essays
    Read More
  • Good Essays

    1103AFE Week 2 Self Study Questions Wit
    • 406 Words
    • 3 Pages

    1103AFE Week 2 Self Study Questions Wit

    1. _Enterprise systems_________________ integrate the business process functionality and information from all of an organization’s functional areas, such as marketing and sales, cash receipts, purchasing, cash disbursements, human resources, production and logistics, and business reporting (including financial reporting)…

    • 406 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Week 5: Homework
    • 384 Words
    • 2 Pages

    Week 5: Homework

    1. Please explain how Charitable Contributions come into play in determining "Corporate" taxable income. (5 pts)…

    • 384 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    The Poisonwood Bible Critical Reading Portfolio Entry
    • 2052 Words
    • 6 Pages

    The Poisonwood Bible Critical Reading Portfolio Entry

    The Poisonwood Bible is a book about the reactions that can be made with the burden of collective guilt; to be specific, to our complicit guilt as citizens of the United States for the misconduct by our nation in the Congo. The Poisonwood Bible is an allusion of an event that triggers the life of a family to be burden with guilt in the Congo. The title of the book is what describes the whole book. The Poisonwood Bible is an increased prosecution of Western colonialism and post-colonimalism, an expose of cultural arrogance and self-indulgence.…

    • 2052 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Good Essays

    Week 7 Quiz Notes
    • 2141 Words
    • 6 Pages

    Week 7 Quiz Notes

    Two high school students took equivalent language tests, one in German and one in French. The student taking the German test, for which the mean was 66 and the standard deviation was 8, scored an 82, while the student taking the French test, for which the mean was 27 and the standard deviation was 5, scored a 35. Compare the scores. Same equation as the question above to find the corresponding z-score. 2 would be better.…

    • 2141 Words
    • 6 Pages
    Good Essays
    Read More
  • Good Essays

    Uop Humanities 176 Week 8 Assignment
    • 1410 Words
    • 6 Pages

    Uop Humanities 176 Week 8 Assignment

    “You are the chief editor of a large metropolitan daily newspaper. One of your reporters is caught fabricating sources and making up facts. How do you handle the situation, from disciplining the reporter to explaining it to your readers?”…

    • 1410 Words
    • 6 Pages
    Good Essays
    Read More
  • Good Essays

    Hild 10 Reading Response Week 8
    • 516 Words
    • 3 Pages

    Hild 10 Reading Response Week 8

    In the readings for this week, from Mair entries 54-59, the various author’s wrote poems to describe the life in Song China. These poets shared their stories by using beautiful imagery to describe it for them. Stories that describe the noise of rats to the paintings of bamboo, the writings of the Song poets conveyed the outlook of the Song Dynasty. Although these poems served as an art for entertainment, the poems, in a deeper way, addressed the thoughts and views of the culture in the Song.…

    • 516 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    PHIL201 Study Guide Lesson 10
    • 731 Words
    • 3 Pages

    PHIL201 Study Guide Lesson 10

    Plato's understanding of knowledge is justified true belief. After rejecting 2 accounts of knowledge (knowledge as perception & knowledge as true belief) , defined as KNOWLEDGE IS SOMETHING SIMILAR TO JUSTIFIED TRUE BELIEF. (PG. 20)…

    • 731 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Week Three Quiz
    • 658 Words
    • 3 Pages

    Week Three Quiz

    1. Why should you never designate minor children as your primary beneficiary, but instead put assets intended for them into a trust?…

    • 658 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Week 4 Quiz
    • 341 Words
    • 2 Pages

    Week 4 Quiz

    a. The emphasis on ethnic foods and ethnically associated political associations instead of deeper ties.…

    • 341 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    To Kill A Mockingbird Reading Journal 2
    • 1857 Words
    • 5 Pages

    To Kill A Mockingbird Reading Journal 2

    1) Choose one complex character from the novel. Using quotations from the text as supporting evidence, examine and explain the devices used by the author to create this complex character. Then, describe how this character has contributed to the development of the plot in Chapters 7-11.…

    • 1857 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Week 4 quiz
    • 604 Words
    • 3 Pages

    Week 4 quiz

    7. When the researcher measures a behavior that needs to be changed, applies therapy and measures the behavior again, and then removes the treatment and measures the behavior again, this is referred to as ABA design.…

    • 604 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    week 2 homework
    • 1170 Words
    • 4 Pages

    week 2 homework

    2.1 It is important to take a balanced approach to risk management because its children's natural inclination to take risks when they play, those responsible for children have to take a balanced, thoughtful approach to managing risk. This is particularly important for play because children today tend to have less freedom than in the past, and hence may have fewer opportunities for risk-taking as a normal part of their everyday lives, however as early years providers we must ensure that we take all reasonable steps to ensure that children in our care are not exposed to risks or that these risks are minimized.…

    • 1170 Words
    • 4 Pages
    Better Essays
    Read More
  • Good Essays

    Week 3 Homework
    • 396 Words
    • 2 Pages

    Week 3 Homework

    Operant Conditioning molds behavior by the consequences of an individual through punishment, reinforcement and extinction. Observational Learning happens from observing the behavior of other individuals. Social Learning is a behavior learned from a social environment. Prejudice is developed and nurture through classical and operant conditioning from an early age when an individual acts prejudice towards something and is rewarded for acting in such a way or saying such things. For example A parent, say father, says (and please do not take offence towards this it is only an example!) “Stupid wet-back, they’re no good for anything but taking our jobs!” a son or daughter will learn that this is applicable behavior. Then when the child, son or daughter, says something along the same lines around his or her father the father would agree, laugh or show affection towards the child’s comment. Thus the behavior is not being corrected allowing the ignorant behavior to continue. For my presentation I would use Rhyme-keys and Loci Method to help me remember notes and slides. I would Use Rhyme-keys for myself on key words in the slides to help me remember key ideas with Loci Method with pictures and diagrams in the slides to better help my memory. For example if I had a slide on the marketing sale rates on, say computers being sold I would use a graph with percentages over time with a scale on sale rate, I would use key words to explain the key points for why there is a clime or fall in sales. Cognitive, physiological, and behavioral are the three qualities. Cognitive is a mental process that involves memory, attention, understanding language, producing language, reasoning, problem solving and decision making. Physiological deals with the understanding of one’s own body, hygiene and appearance. Emotional is in regards to self-awareness, self-regulation, motivation, empathy and social skills. If I were interviewing applicants for a position in my company I…

    • 396 Words
    • 2 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Humanities 101 Learning Activity 8
    • 306 Words
    • 2 Pages

    Humanities 101 Learning Activity 8

    It is hard to imagine going back in time 500 years ago, however, I’m sure how so many 500 years ago from right now felt too, hard to imagine, right? There is so much that has changed in the last 500 years, it is nearly impossible to imagine what life was like there on the ground floor of 2013. They say that hindsight is 20-20, and I think that a couple words that would describe the current age would be hedonism and selfishness. 2013 was time where people wanted to do whatever pleased them most without any consequences. They cared less about other people than they did the environment and protecting their own feelings from every little thing. It was a time when everyone felt as though they either were or should’ve been an exception to the rule, which rule? Basically any and all of them. It had become a very partisan time, and those who didn’t fit into the liberal mold were cast aside, ridiculed and thusly their integrity was stripped from them unduly. It was a time where up was down and down was up, people were venerated for bad behavior and those who chose to do the right things were treated like criminals. Everyone wanted to take from the system and upon receiving it would turn around and bite the hand that fed them. People are wanting more and more from their government and giving less and less back to it. This is becoming dangerous close to a serious financial breakdown. This was a time of entitlement; so many people seemed to feel that they were due something from just about everyone regardless of whether or not they deserved it, or earned it. This is just perspective from a humble historians opinion, but 2013 was definitely backwards in time.…

    • 306 Words
    • 2 Pages
    Satisfactory Essays
    Read More

Related Topics