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...
-
Hartl Enterprises issued ten $1,000 bonds on September 30, 2014, with a stated annual interest rate of 8 percent. These bonds will mature on October 1, 2024, and have an effective rate of 10 percent....
-
You are analyzing Tiffanys, an upscale retailer, and find that the regression estimate of the firms beta is 0.75; the standard error for the beta estimate is 0.50. You also note that the average...
-
Discuss the potential fundraising effectiveness of a board with or without a development committee.
-
Vanna Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company...
-
Emergency Management and Large Data, Social Media, Radio and Satellite Communications, GIS discuss what information EM would want to be able to surface in the EOC and on a GIS map to help with the...
-
Antelopes, native to Africa and Asia, range in size from 30 cm to over 180 cm at the shoulder, with most between 90-120 cm. This is related to the humerus length. The data below gives the length and...
-
Classify whether each one is job order costing system or process costing system? And why 1. Famous Cheese Spread was created by a family in a small town in Nebraska. Its website says it sells to...
-
3) Using a single SQL statement give a listing of all the patients who have Diabetes and are older than 95 4) Using a single SQL statement give a listing of all the disease descriptions of where the...
-
How do security considerations intersect with virtual memory design, and what vulnerabilities arise from memory-based attacks such as buffer overflows, code injection, and privilege escalation,...
-
Suppose as a student of AIBA Savar you are interested to know about the financial situation and quality assurance of the canteen. For that you have to evaluate the "Financial Statements" by ratio...
-
What advancements have been made in virtual memory research to address the scalability challenges posed by increasingly large-scale and heterogeneous computing systems, including innovations in...
-
(a) How may a Chinese national acquire Hong Kong permanent residence? (7 marks) (b) How may a non-Chinese national acquire Hong Kong permanent residence? (6 marks) (c) While adjudicating cases, if...
-
GIVE A DETAILED PROJECT CHARTER FOR THE CASE Fuddruckers and the Cyrstal Coast Music Festival.
-
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?
-
Alleghany Technologies Incorporated disclosed in its annual report that: Discuss why a liquidation of LIFO inventory quantities would reduce a companys cost of goods sold. Does this event indicate...
-
The Financial Times reported that Delphi, Inc., a manufacturer of automotive parts, would take a \($100\) million write-down of its inventory to reflect reduced demand for some of its products. The...
-
The following information was disclosed in the 2015 annual report of The Arcadia Company. Fill in the missing values. Beginning inventory. Purchase of inventory.. Inventory available for sale. Ending...
Study smarter with the SolutionInn App