Using the REA approach to developing a database for an accounting system, you have identified one...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the REA approach to developing a database for an accounting system, you have identified one event, or activity, that needs to be included in the database. The event is a purchase from a vendor. The organization makes over-the-counter purchases in which the purchasing agent makes a purchase and immediately receives the goods purchased. All purchases are on account, and the company uses a voucher number to uniquely identify all purchases. Required: a. Identify any resources and agents that are related to the purchase event. Document the event and any resources and agents with an E-R diagram. b. Identify the relationship among the events, resources, and agents. Add these relationships to your E-R diagram. Indicate on your E-R diagram the type of each relationship that is, 1:1,1:*, *:1, or *.*. c. Identify and list the attributes that are related to the resources, events, agents, and relationships. d. Create the appropriate database tables by referring to the E-R diagram. Using the REA approach to developing a database for an accounting system, you have identified one event, or activity, that needs to be included in the database. The event is a purchase from a vendor. The organization makes over-the-counter purchases in which the purchasing agent makes a purchase and immediately receives the goods purchased. All purchases are on account, and the company uses a voucher number to uniquely identify all purchases. Required: a. Identify any resources and agents that are related to the purchase event. Document the event and any resources and agents with an E-R diagram. b. Identify the relationship among the events, resources, and agents. Add these relationships to your E-R diagram. Indicate on your E-R diagram the type of each relationship that is, 1:1,1:*, *:1, or *.*. c. Identify and list the attributes that are related to the resources, events, agents, and relationships. d. Create the appropriate database tables by referring to the E-R diagram.
Expert Answer:
Related Book For
The Future of Business
ISBN: 978-0176570255
5th edition
Authors: Norm Althouse, Laura Allan, Christopher Hartt
Posted Date:
Students also viewed these accounting questions
-
What needs to be included in a business plan? What is the business plan used for?
-
What internal control documentation needs to be included in the audit files?
-
Design a database for an automobile company to provide to its dealers to assist The minmaintaining customer records and dealer inventory and to assist sales staff in ordering CMS. Each vehicle is...
-
Suppose you own an outdoor recreation company and you want to purchase all-terrain vehicles (ATVs) for your summer business and snowmobiles for your winter business. Your budget for new vehicles this...
-
A primitive economy has a mining industry and a fishing industry, with technology matrix A. If surpluses of 147 units of mining output and 26 units of fishing output are desired, find the gross...
-
Which of the following statements are correct? Explain your answers. A. A DNA strand has a polarity because its two ends contain different bases. B. G-C base pairs are more stable than A-T base pairs.
-
Identify the environmental forces that shape global marketing efforts.
-
Humphrey Manufacturing produces automobile parts and batteries. All direct materials are added at the beginning of production, and conversion costs are incurred evenly throughout production. The...
-
A commercial office lease requires an immediate payment of $24,000 plus $24,000 per year at the end of each of the next 10 years. At a discount rate of 14 percent, what is the present value of this...
-
The next diagram depicts a system of aqueducts that originate at three rivers (nodes R1, R2, and R3) and terminate at a major city (node T), where the other nodes are junction points in the system....
-
In the accounting profession there are several codes set by AICPA. I would determine the integrity principle as the driver that impact all of the others. What are some examples of this in the...
-
PART 1: DIGITAL TECHNOLOGY: Describe the key digital technology groups studied in this course and include a discussion of two examples for each group. PART 2: SOCIAL MEDIA: As studied in this course,...
-
Doing a strategic analysis of GraceKennedy Limited, What is the current level of its economic performance, an indication of the factors responsible for the current performance and recommendations for...
-
Dynamic capability is the ability for change and manage corporate learning. It allows an enterprise to adapt, develop and respond to future opportunities and discontinuous technologies. Innovation...
-
What potential solutions can organizations try to help support the adoption of a CDSS? In other words, what are some ways an organization can address the factors of implementation obstruction that...
-
Identify and briefly describe and discuss the three most important factors in building and maintaining trust among virtual global team members. Include in your discussion how you can leverage these...
-
Moody Corporation uses a job-order costing system with a plantwide predetermined overhead rate based on machine-hours. At the beginning of the year, the company made the following estimates:...
-
Draw the major product for each of the following reactions: (a) (b) (c) 1) 9-BBN 2) H2O2, NaOH 1) Disiamylborane 2) H20, NaOH
-
How are business products classified?
-
How can technology be used to improve operating efficiencies and the ability for companies to compete?
-
What are the five basic types of departmentalization that are commonly found in organizations?
-
TRACING PORTO PEROEN ANCE. Use Work sheet 11.2to help Grant and Ble Harding, a married couple in their early 30s, evaluate their securities portfolio, which includes these holdings. a. IBM. (NYSE;...
-
MAR IT AND UNIT ORDERS. Victor Gould places an order to buy 100 shares of Google. Explain how the order will be processed if it's a mar ket order. Would it make any difference if it had been a limit...
-
TYPES OF FINANCIAL MAR ETS. What is the differ- ence between primary and secondary markets and between broker and dealer markets?? L01
Renegade Dreams Living Through Injury In Gangland Chicago 1st Edition - ISBN: 022603271X - Free Book
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App