Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 2P
To determine
Draft a memorandum to explain the advantages of DBMS to top management team at the company M. Also, explain the need and role of database administrator.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Sears Roebuck, the most well-known and oldest mail-order retailer in the country, discontinued its mail-order operations in 1993. Other mail-order marketers are using information systems to trim printing and postage costs of their catalogs. They also want to more effectively target their customers. Explain how an appropriately designed coding system for inventory items, incorporated in a relational database system with SQL capabilities, could allow more cost-efficient and effective mail-order operations. Sketch the necessary database table structure.
Below are the benefits of computerised accounting syste,.Explain and give example on the below keypoints.
• Instant Reporting
• Reduction in Paper Work - Now most of the work is done via computerised system. Hence, their is less need of manual work.
• Flexible Reporting
• Accounting Queries
• Online Facility - All the data can be make available online anywhere and anytime to any manager.
• Security - All data is stored in computer with strong passwords and usernames.
2. The importance of input editing increases with the complexity of EDP systems.a. What is meant by input editing?b. Give two examples each of input editing routines for payroll processing and those for sales order processing.c. Why does input editing become increasingly significant as the complexity of EDP systems increases?
Chapter 9 Solutions
Accounting Information Systems
Ch. 9 - Prob. 1RQCh. 9 - Prob. 2RQCh. 9 - Prob. 3RQCh. 9 - Prob. 4RQCh. 9 - Prob. 5RQCh. 9 - Prob. 6RQCh. 9 - Prob. 7RQCh. 9 - Prob. 8RQCh. 9 - Prob. 9RQCh. 9 - Prob. 10RQ
Ch. 9 - Prob. 11RQCh. 9 - Prob. 12RQCh. 9 - Prob. 13RQCh. 9 - Prob. 14RQCh. 9 - Prob. 15RQCh. 9 - Prob. 16RQCh. 9 - Prob. 17RQCh. 9 - What are the conditions for third normal form...Ch. 9 - Prob. 19RQCh. 9 - Prob. 20RQCh. 9 - Prob. 21RQCh. 9 - What is a user view?Ch. 9 - Prob. 23RQCh. 9 - Prob. 24RQCh. 9 - Prob. 25RQCh. 9 - Prob. 1DQCh. 9 - Prob. 2DQCh. 9 - Prob. 3DQCh. 9 - Prob. 4DQCh. 9 - Prob. 5DQCh. 9 - Prob. 6DQCh. 9 - Prob. 7DQCh. 9 - Prob. 8DQCh. 9 - Prob. 9DQCh. 9 - Prob. 10DQCh. 9 - Prob. 11DQCh. 9 - Prob. 12DQCh. 9 - Prob. 13DQCh. 9 - Prob. 14DQCh. 9 - Prob. 15DQCh. 9 - Discuss the accounting implications of the update,...Ch. 9 - Prob. 17DQCh. 9 - Prob. 18DQCh. 9 - Prob. 19DQCh. 9 - Prob. 20DQCh. 9 - Prob. 1MCQCh. 9 - Prob. 2MCQCh. 9 - Prob. 3MCQCh. 9 - Prob. 4MCQCh. 9 - Prob. 5MCQCh. 9 - Prob. 6MCQCh. 9 - Prob. 7MCQCh. 9 - Prob. 8MCQCh. 9 - Prob. 9MCQCh. 9 - Prob. 10MCQCh. 9 - Prob. 11MCQCh. 9 - Prob. 12MCQCh. 9 - Prob. 13MCQCh. 9 - Prob. 14MCQCh. 9 - Prob. 15MCQCh. 9 - Prob. 16MCQCh. 9 - Prob. 17MCQCh. 9 - Prob. 18MCQCh. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - Prob. 2PCh. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Prob. 4PCh. 9 - Prob. 5PCh. 9 - Prob. 6PCh. 9 - Prob. 7PCh. 9 - Prob. 8PCh. 9 - Prob. 9PCh. 9 - Prob. 10PCh. 9 - Prob. 11PCh. 9 - Prob. 12PCh. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Prob. 14PCh. 9 - Prob. 15PCh. 9 - Prob. 16PCh. 9 - Prob. 17PCh. 9 - Prob. 18PCh. 9 - Prob. 21PCh. 9 - Prob. 22PCh. 9 - Prob. 23PCh. 9 - Prob. 24P
Knowledge Booster
Similar questions
- LAWN WIZARD INC. (MANUAL SYSTEM WITH STAND-ALONE PC SUPPORT) Law Wizard Inc. (LWI) is a manufacturer of a range of walk-behind gasoline lawnmowers, which it markets to garden centers and home improvement centers. LWI employs a batch production process whose inventory management, production planning, and accounting procedures consist of a combination of manual activities supported by stand-alone (non-networked) PC technology. The company is experiencing production delays and cost overruns. Its CEO has hired your firm to review its procedures and make recommendations for improving its operations. The batch production process is initiated by receipt of individual customer orders, which are grouped together in batches for manufacturing. The production planning and control clerk enters the orders into the digital production schedule from his department PC and prints two hard-copy work orders. He sends one of these to cost accounting and the other to the production department. The production department supervisor enters the work order into a PC application. The system automatically creates an open work order record and prints the hard-copy move tickets and materials requisitions. The supervisor distributes the move tickets and two copies of the purchase requisitions to each work center invoked in the production process. Work center employees exchange the material requisitions for assembly parts and other materials needed to complete the batch. If additional parts or materials are needed beyond the standard quantity, the supervisor issues additional material requisitions. As the production is completed in each work center, employees record their labor time for each batch on hard-copy job cards, which they send to cost accounting along with the move ticket. Finally, upon completion of the batch, the supervisor closes the open work order file. The storekeeping clerk files one copy of the material requisition in the department and updates the raw materials inventory file from the computer in his office. The manager then sends the second copy of the material requisition to cost accounting. At the end of the day, the manager prepares a hard-copy journal voucher and sends it to the general ledger department. The cost accounting clerk receives the work order and sets up a WIP account for the batch. Throughout the production period, the clerk also receives move tickets, job tickets, and materials requisitions, which she uses to post to WIP. At the end of each day, the cost accounting clerk prepares a hard-copy journal voucher, which she sends to general ledger department. The journal voucher reflects the total value of WIP and transfers to finished good inventory. The general ledger clerk receives the journal vouchers, posts to the appropriate GL accounts, and files the journal vouchers in the department. Required a. Create a system flowchart of the existing system. b. What risks exist in the system as it is currently designed? c. Describe the changes needed to reduce the risks.arrow_forwardWhich of the following is a risk to the financial statement of a company when it places a purchase order with a supplier? The advantages of PDF files are: A. that they can be securely locked so that the figures cannot be changed.B. that they can be easily manipulated and changed by users.C. the software to produce them is very cheap.D. none of the options are correct. 2. What is information overload? A. The situation where a computer has more information than is needed or is able to be processed in a meaningful way when a computer program is executed.B. The situation where an individual has more information than is needed or is able to be processed in a meaningful way when working through a decision.C. The situation where a computer has more information than is needed or is able to be processed when data storage is taking place.D. The situation where the amount of information exceeds the storage capacity of the brain of a human being. 3. When all data are stored in a central place,…arrow_forwardSystems Analysis Consider the following dialogue between a systems professional, Joe Pugh, and a manager of a department targeted for a new information system, Lars Meyer: Pugh: The way to go about the analysis is to first examine the old system, such as reviewing key documents and observing the workers perform their tasks. Then we can determine which aspects are working well and which should be preserved. Meyer: We have been through these types of projects before and what always ends up happening is that we do not get the new system we are promised; we get a modified version of the old system. Pugh: Well, I can assure you that will not happen this time. We just want a thorough understanding of what is working well and what is not. Meyer: I would feel much more comfortable if we first started with a list of our requirements. We should spend some time up-front determining exactly what we want the system to do for my department. Then you systems people can come in and determine what…arrow_forward
- The computer processing portion of a sales order system is represented by the flowchart. Answer the following questions.a. What type of data processing system is this? Explain, and be specific.b. The auditor suggests that this system can be greatly simplified by changing to direct access files. Explain the major operational changes that would occur in the system if this were done.c. The auditor warns of control implications from this change that must be considered. Explain the nature of the control implications.d. Sketch a flowchart (the computerized portion only) of the proposed new system. Use correct symbols and label the diagram.arrow_forwardSystems Planning A new systems development project is being planned for the Reindeer Christmas Supplies Company. The invoicing, cash receipts, and accounts payable modules are all going to be updated. The controller, Kris K. Ringle, is a little anxious about this project. The last systems development project that affected his department was not very successful,and the employees in the accounting department did not accept the new system very well at first. He feels that the systems personnel did not interact sufficiently with the users of the systems in the accounting department. Prepare a memo from Ringle to the head of the information systems department, Sandy Klaus. In this memo, provide some suggestions for including the accounting personnel in the systems development project. Give some very persuasive arguments why prototyping would be helpful to the workers in the accounting department.arrow_forwardIncreasing use of sophisticated EDP systems has produced significant changes in the accounting environment. Some of these changes are the following: documents that are used to enter information into the computer may exist for only a short time or only in computer-readable form. In some computer systems, input documents may not exist at all, because information is entered directly into the system. Computer processing uniformly subjects like transactions to the same processing instructions. Many internal control procedures, once performed by separate individuals in manual systems, may be combined in systems that use computer processing. The potential for individuals to gain unauthorized access to data or assets may be greater in computerized accounting systems than in manual systems. Required: For each of the changes, discuss the impact on the internal control system and the independent audit.arrow_forward
- A new system development project is being planned for Consti Corporation. The invoicing, cash receipts, and accounts payable modules are all going to be updated. You are the controller of ConstiCorporation, and you are a little anxious about the aforementioned project. The last systems development project that affected your department was not very successful, and the employees in the accounting department did not accept the new system very well at first. You feel that the systemspersonnel did not interact sufficiently with the users of the systems in the accounting department. Required: Prepare a memo that you will send to Anna Marie, the head of the information systems department. In the memo, provide some suggestions about the new project, including your concernabout the accounting personnel in the systems development project. Give persuasive arguments why prototyping would be helpful to the workers in the accounting department.arrow_forwardAssume that you produce plastic computer pieces for computer companies. The pieces require very little technology. Where would you like to establish DFI? (The point of this question is to force consideration of various characteristics that are incorporated in a DFI decision.)arrow_forwardConsider the following dialogue between a systems professional, Joe Pugh, and a manager of a department tar- geted for a new information system, Lars Meyer:Pugh: The way to go about the analysis is to first examine the old system, such as reviewing key documents and observing the workers performing their tasks. Then we can determine which aspects are working well and which should be preserved. Meyer: We have been through these types of projects before and what always ends up happening is that we do not get the new system we are promised; we get a modified version of the old system.Pugh: Well, I can assure you that will not happen this time. We just want a thorough understanding of what is working well and what is not.Meyer: I would feel much more comfortable if we first started with a list of our requirements. We should spend some time up front determining exactly what we want the system to do for my department. Then, you systems people can come in and determine what portions to…arrow_forward
- has hired you to review its sales order procedures for internal control compliance and to make recommendations for changes. You are required to:a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the internal control weaknesses in the system. ; andd. Prepare a system flowchart of a redesigned computer-based systemarrow_forwardCorrecting internal control weakness Each of the following situations has an internal control weakness. Jade Applications has decided that one way to cut costs in the upcoming year is to fire the external auditor. The business believes that the internal auditor should be able to efficiently monitor the company’s internal controls. In an effort to minimize the amount of paperwork, Ross Homes has decided that it will not keep copies of customer invoices related to sales revenue. Ross believes that this effort will minimize the amount of data storage the company will have to pay for. Elle Bee, a trusted employee for many years, has never taken a vacation. The owner believes that he’s lucky that she is so committed to her job. The Medicine Chest Company keeps a small petty cash fund to handle small cash transactions. Because no one wants to volunteer to be the custodian, the business manager has decided that all employees should have access to the petty cash. She figures that as long as…arrow_forwardLamar LLC is in the process of updating its revenues and receivables systems with the implementation of new accounting software. James Loden, Inc. is an independent information technology consultant who is assisting Tamar with the project. James has developed the following checklist containing internal control points that the company should consider in this new implementation: Will different system access levels for different users be incorporated?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning