Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 11, Problem 3P
a.
To determine
State the appropriate process from OLAP or OLTP and the reason for it.
b.
To determine
State the appropriate process from OLAP or OLTP and the reason for it.
c.
To determine
State the appropriate process from OLAP or OLTP and the reason for it.
d.
To determine
State the appropriate process from OLAP or OLTP and the reason for it.
e.
To determine
State the appropriate process from OLAP or OLTP and the reason for it.
f.
To determine
State the appropriate process from OLAP or OLTP and the reason for it.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
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…
For each of the following processes, state whether OLTP or OLAP is appropriate, and why.
a. An order entry system that retrieves customer information, invoice information, and inventory information for local sales.
b. An order entry system that retrieves customer information, invoice information, inventory information, and several years of sales informa- tion about both the customer and the inventory items.
c. An order entry system that retrieves customer information, invoice information, inventory infor- mation, and information to compare the current sale to sales across several geographic regions.
d. An order entry system that retrieves customer information, invoice information, inventory information, and accounts receivable informa- tion for sales within one marketing region.
e. 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 more…
For each of the following processes, state whether OLTP or OLAP is appropriate and why.a. An order entry system that retrieves customer information, invoice information, and inventory information for local sales.b. 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.c. 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.d. An order entry system that retrieves customer information, invoice information, inventory information, and accounts receivable information for sales within one marketing region. e. An insurance company requires a system that will allow it to determine total claims by region, determine whether a relationship exists between claims and meteorological phenomenon, and why one region seems to be more…
Chapter 11 Solutions
Accounting Information Systems
Ch. 11 - Define ERP.Ch. 11 - Prob. 2RQCh. 11 - Define core applications, and give some examples.Ch. 11 - Prob. 4RQCh. 11 - Prob. 5RQCh. 11 - Prob. 6RQCh. 11 - Prob. 7RQCh. 11 - Prob. 8RQCh. 11 - Prob. 9RQCh. 11 - Prob. 10RQ
Ch. 11 - Prob. 11RQCh. 11 - Prob. 12RQCh. 11 - Prob. 13RQCh. 11 - Prob. 14RQCh. 11 - Prob. 15RQCh. 11 - Prob. 16RQCh. 11 - Prob. 17RQCh. 11 - Prob. 18RQCh. 11 - Prob. 19RQCh. 11 - Prob. 20RQCh. 11 - Prob. 21RQCh. 11 - Prob. 22RQCh. 11 - Prob. 23RQCh. 11 - How are OLTP and OLAP different? Provide some...Ch. 11 - Prob. 2DQCh. 11 - Why do ERP systems need bolt-on software? Give an...Ch. 11 - Your organization is considering acquiring bolt-on...Ch. 11 - Prob. 5DQCh. 11 - Prob. 6DQCh. 11 - Prob. 7DQCh. 11 - Prob. 8DQCh. 11 - Prob. 9DQCh. 11 - Prob. 10DQCh. 11 - Prob. 11DQCh. 11 - ERP systems use the best-practices approach in...Ch. 11 - Prob. 13DQCh. 11 - Explain how SAP uses roles as a way to improve...Ch. 11 - Prob. 15DQCh. 11 - Prob. 16DQCh. 11 - Distinguish between the OLAP operations of...Ch. 11 - When would slicing and dicing be an appropriate...Ch. 11 - Prob. 19DQCh. 11 - What is the fundamental concept behind the rule of...Ch. 11 - What is the purpose of role-based governance...Ch. 11 - Prob. 1MCQCh. 11 - Prob. 2MCQCh. 11 - Prob. 3MCQCh. 11 - Prob. 4MCQCh. 11 - Prob. 5MCQCh. 11 - Prob. 6MCQCh. 11 - Which statement is LEAST accurate? a. Implementing...Ch. 11 - Prob. 8MCQCh. 11 - Auditors of ERP systems a. need not be concerned...Ch. 11 - Prob. 10MCQCh. 11 - Prob. 1PCh. 11 - Your organization is planning to implement an ERP...Ch. 11 - Prob. 3PCh. 11 - Prob. 4PCh. 11 - Prob. 5PCh. 11 - Prob. 6PCh. 11 - Prob. 7PCh. 11 - Prob. 8PCh. 11 - Prob. 9P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Record the following transactions in the sales journal:arrow_forwardWhich 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 & Barrow_forwardDescribe briefly the processing of transactions, including internal control features, in the following functions under the sales and collection cycle:a. order entryb. customer billingarrow_forward
- When aninventory itemfalls to the recorder point, a purchase requisition is automatically generated and printed on the terminal in the purchasing department. The purchasing clerk select suppliers and prepare a purchase order. One copy of the purchase order is sent to the supplier and another copy is sent to the receiving department. The purchasing clerk then adds a record to the open/closed purchase order file through an update program in the data processing department.When the receiving clerk receivesthe delivery from the supplier, the clerkreconciles the items with the packing slip and the purchasing order. After the reconciliation, the receiving clerk prepares a hard-copy receiving report recording the quantity and quality of the goods received. One copy of the receiving report accompaniesthe items to the warehouse and another copy is filed in the receiving department. Using the department terminal, the receiving clerk adds a record to the digital receiving report file. The system…arrow_forwardGiven 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…arrow_forwardThe purchases and disbursements cycle usually begins when Group of answer choices A user department requests for acquisition of goods or services and submits purchase requisition to the purchasing department. A check is issued to the vendor or supplier. The warehouse received the goods from the vendor or supplier. The accounting posts the purchase transaction in the accounts payable ledger.arrow_forward
- 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?arrow_forwardIdentify which department has stewardship over the following journals,ledgers,and files. a.customer open order file b.sales journal c.cash receipts journal d.cash receipts journal e.Inventory subsidiary ledger f.Accounts receivable subsidiary ledger g.Sales history file h.Shipping report file I.credit memo filr j.sales order file k.closed sales order filearrow_forwardthe purchases and disbursements cycle usually begins when a. a user department request for acquisition of goods or services and submits purchase requisition to the purchasing department b. a check is issued to the vendor or supplier c. the warehouse is received the goods from the vendor or supplier d. the accounting posts the purchase transaction in the accounts payable ledgerarrow_forward
- Describe the step-by-step processes that are occurring in the flowchart. Describe using bullet points.arrow_forwardThe 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_forwardIn a good internal control system, which of the following sets of documents is required for proper approval of a payment to a supplier? A. a journal entry, a supplier invoice, and a description of the goods being purchased B. a supplier invoice, a bill of lading, and the supplier's financial statements C. a purchase order, a journal entry, and a price catalog D. a receiving report, an invoice, and a purchase orderarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
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
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub