Accounting Information Systems
11th Edition
ISBN: 9781337552127
Author: Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 1SP
Summary Introduction
To draw: An Entity relationship diagram and an REA model.
Introduction:
Database management systems (DBMS):
It is computer software for creating and managing databases. The DBMS provides a way for the users to create, update, retrieve and manage the data present in the database. It also supports the administration and use of the database on different platforms.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Sunset Graphics often buys inventory after receiving a sales order from the customer. Suppose you are asked to prepare one UML class diagram that combines both the sales and collection process and the purchases and payments process. What would be shared among those processes? What would be unique to each process? Why?
OLTP VERSUS OLAP SERVERS
For each of the following processes, state whether OLTP or OLAP is appropriate, and why.
An order entry system that retrieves customer information, invoice information, and inventory information for local sales.
An order entry system that retrieves customer information, invoice information, inventory information, and several years of sales information about both the customer and the inventory items. An order entry system that retrieves customer information, invoice information, inventory information, and information to compare the current sale to sales across several geographic regions.
An order entry system that retrieves customer information, invoice information, inventory information, and accounts receivable information for sales within one marketing region.
An insurance company requires a system that will allow it to determine total claims by region, whether a relationship exists between claims and meteorological phenomena, and why one region seems to be…
Given the following business rules, construct an ER diagram so each rule is captured for the database. Presume each rule is to be treated individually. Construct an ER diagram for each rule.a. A retail sales company prepares sales orders for its customers’ purchases. A customer can make many purchases, but a sales order is written for a single customer.b. A retail sales company orders inventory using a purchase order. An inventory item may be ordered many times, and a purchase order may be created for more than one inventory item.c. A company that sells antique cars prepares a sales order for each car sold. The inventory for this company consists of unique automobiles, and only one of these automobiles may be listed on a sales order.d. A grocery store identifies returning customers via a plastic card that the clerk scans at the time of each purchase. The purpose of this card is to track inventory and to maintain a database of customers and their purchases. Obviously, a customer may…
Chapter 5 Solutions
Accounting Information Systems
Ch. 5 - Prob. 1RQCh. 5 - Prob. 2RQCh. 5 - Prob. 3RQCh. 5 - What are the most important limitations of the...Ch. 5 - Prob. 5RQCh. 5 - Prob. 6RQCh. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Prob. 10RQ
Ch. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - What is a partial dependency?Ch. 5 - Prob. 15RQCh. 5 - Prob. 16RQCh. 5 - Prob. 17RQCh. 5 - What factors distinguish DSS from EIS?Ch. 5 - Describe the basic differences between ES and NN.Ch. 5 - What role do intelligent agents play in the...Ch. 5 - Why have knowledge management systems become so...Ch. 5 - Prob. 22RQCh. 5 - Prob. 23RQCh. 5 - Prob. 1DQCh. 5 - How has the technological availability and...Ch. 5 - Prob. 3DQCh. 5 - Prob. 4DQCh. 5 - What are the differences between a logical view...Ch. 5 - Prob. 6DQCh. 5 - Prob. 7DQCh. 5 - Prob. 8DQCh. 5 - Prob. 9DQCh. 5 - Prob. 10DQCh. 5 - Prob. 11DQCh. 5 - Prob. 12DQCh. 5 - Prob. 1SPCh. 5 - Prob. 2SPCh. 5 - Prob. 7PCh. 5 - Prob. 12PCh. 5 - Use the Internet to research knowledge management...
Knowledge Booster
Similar questions
Keeping in mind the management Accounting control system (MACS) can you relate the customer demand with supplier cost estimation?
arrow_forward
. Discuss how reengineering process of sales order processing subsystem be accomplished using the Internet
arrow_forward
List some AIS and MIS information from which sales people may benefit. Clearly indicate whether the information item would be an output of a traditional AIS or MIS system. Finally, discuss the benefits of integrating this information.
arrow_forward
Briefly inform these stakeholders of the benefits of automation on the current business processes within the shipping industry, specifically referencing the benefits of using a spreadsheet solution and how easy it was to process data.
arrow_forward
The outputs of a computerized accounting information system are called
Reports.
Software.
Processing.
Purchase invoices.
arrow_forward
Which of the following activities would use number of customer orders as an activity base?
A.
Order shipping
B.
Invoicing & collecting
C.
Customer return processing
D.
Both A & B
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_forward
Expound the following two physical control for small tool inventory:
1) Organization should use scanners and other physical counting technology for small tool inventory because it is a high amount of quantity so it's need some technology.
2) Organization need to create proper designed location names and each item should be label where the item is stored.
arrow_forward
.Internal Controls and RiskReview the following description of the purchasing and AP procedures for a company and answer the questions at the end.The purchasing agent receives an inventory status report on his computer terminal from the inventory control application, which identifies the items that need to be reordered. The agent selects the suppliers and enters this information into the computer terminal to create a digital purchase order. He then prints and sends a copy of the PO to the supplier.When the goods are received directly into the warehouse, the warehouse manager counts and inspects them. The manager then creates a digital receiving report and updates the inventory subsidiary ledger from the warehouse terminal.A few days later, the supplier sends an invoice to the AP clerk who reconciles it with the digital copy of the receiving report. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP…
arrow_forward
Which of the following is an advantage of using a perpetual inventory system
A. It is effective with hand written inventory cards
B. It is able to detect when errors are made
C. It is relatively easy and inexpensive to set up
D. It is less time consuming than other methods
arrow_forward
The purchasing agent receives an inventory status report on his computer terminal from the inventory control application, which identifies the items that need to be reordered. The agent selects the suppliers and enters this information into the computer terminal to create a digital purchase order. He then prints and sends a copy of the PO to the supplier.
When the goods are received directly into the warehouse, the warehouse manager counts and inspects them. The manager then creates a digital receiving report and updates the inventory subsidiary ledger from the warehouse terminal.
A few days later, the supplier sends an invoice to the AP clerk who reconciles it with the digital copy of the receiving report. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP subsidiary ledger and assigning a due date.
Each day, the cash disbursement clerk visually searches the AP subsidiary ledger from her terminal…
arrow_forward
The purchasing agent receives an inventory status report on his computer terminal from the inventory control application, which identifies the items that need to be reordered. The agent selects the suppliers and enters this information into the computer terminal to create a digital purchase order. He then prints and sends a copy of the PO to the supplier.When the goods are received directly into the warehouse, the warehouse manager counts and inspects them. The manager then creates a digital receiving report and updates the inventory subsidiary ledger from the warehouse terminal.A few days later, the supplier sends an invoice to the AP clerk who reconciles it with the digital copy of the receiving report. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP subsidiary ledger and assigning a due date.Each day, the cash disbursement clerk visually searches the AP subsidiary ledger from her terminal for…
arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning