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...
-
Using the information in E15.9, how would your answer differ if Sprague, Inc., had declared a 50 per-cent stock dividend?
-
Proceed as in Example 11.13 to find all abelian groups, up to isomorphism, of the given order. Order 1089 Data from example 11.13 Find all abelian groups, up to isomorphism, of order 360. The phrase...
-
A truck carrying chickens is too heavy for a bridge that it needs to cross. The empty truck is within the weight limits; with the chickens it is overweight. It is suggested that if one could get the...
-
Mercer, Inc., and Tivolian Enterprises are competitors in the toy industry. Last year the companies' operations were identical, the only difference between them being that Mercer uses the last-in,...
-
Crude oil has a storage cost equivalent to 8 per cent per year for all maturities. The spot price of crude oil is $100 per barrel and the 6 and 12 months prices for futures contracts on crude oil are...
-
ACCT 326 Accounting System Review This project requires you to evaluate a PC-based accounting system to see how the system handles recording transactions, collecting data, and generating reports and...
-
You are considering adding new financial assets to your portfolio. You observe that a mutual fund has a beta of 1.2 and an expected return of 7%. The risk-free rate is currently 1% and the market is...
-
What is meant by regulatory arbitrage? How are banks able to lower regulatory capital through securitization? How have the regulators responded?
-
In the market for reserves, what determines demand? What determines supply? How does an increase in the discount rate affect supply? An increase in Treasury deposits at the central bank? An open...
-
What are regarded to be structured securities? How do these utilize passthroughs? What distinguishes the different tranches in a structured security? What is meant by the Z or equity tranche? How...
-
Explain why the market for securitized HELOCs was battered more by the financial crisis (and bursting of the real estate bubble) than the market for GSE MBSs.
-
What are the differences between Ginnie Mae MBSs and those of Fannie Mae and Freddie Mac? Which might be regarded as having the lowest credit risk for investors?
-
detects and corrects the error. /*The Expected Output*/ Enter the scheme of code 11 Write a Java program that computes the Hamming Code which 7 The Scheme of hamming code is (11,7) Enter the 7-bit...
-
Test whether the 5-year survival rate for breast cancer is significantly different between African American and Caucasian women who are younger than 50 years of age and have localized disease....
-
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?
-
What are the three types of employees who work in MNEs? Explain how an HCN could change to become a TCN in an MNE.
-
A large MNE in the cookware industry was having difficulties maintaining its market share due to a number of mergers among other competing firms in the industry. The MNE, with corporate headquarters...
-
What are the different types of organizational forms that corporations use for international operations?
Study smarter with the SolutionInn App