Accounting Information Systems
9th Edition
ISBN: 9781133934400
Author: James A. Hall
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 14, Problem 2P
To determine
Prepare the data flow diagram for the context, intermediate and elementary level for Company SWS.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Sawicki Music Supply is a mail-order business that accepts merchandise orders by telephone and mail. All payments must be prepaid with a major credit card. Once an order is received, either the item is found in inventory and shipped immediately, the item is not found in inventory and is ordered from the manufacturer, or a notice is sent to the customer indicating that the item is no longer stocked. Required Prepare a context, intermediate, and elementary-level data flow diagram for Sawicki Music Supply. For the elementary-level diagram, explode the inventory function.
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…
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…
Chapter 14 Solutions
Accounting Information Systems
Ch. 14 - Prob. 1RQCh. 14 - Prob. 2RQCh. 14 - Prob. 3RQCh. 14 - Prob. 4RQCh. 14 - Prob. 5RQCh. 14 - Prob. 6RQCh. 14 - Prob. 7RQCh. 14 - Prob. 8RQCh. 14 - Prob. 9RQCh. 14 - Prob. 10RQ
Ch. 14 - Prob. 11RQCh. 14 - Prob. 12RQCh. 14 - Prob. 13RQCh. 14 - Prob. 14RQCh. 14 - Prob. 15RQCh. 14 - Prob. 16RQCh. 14 - Prob. 17RQCh. 14 - Prob. 18RQCh. 14 - Prob. 19RQCh. 14 - Prob. 20RQCh. 14 - Prob. 21RQCh. 14 - Prob. 22RQCh. 14 - Prob. 23RQCh. 14 - Prob. 24RQCh. 14 - Prob. 25RQCh. 14 - Prob. 26RQCh. 14 - Prob. 27RQCh. 14 - Prob. 28RQCh. 14 - Prob. 29RQCh. 14 - Prob. 30RQCh. 14 - Prob. 31RQCh. 14 - Prob. 32RQCh. 14 - Prob. 33RQCh. 14 - Prob. 34RQCh. 14 - Prob. 35RQCh. 14 - Prob. 36RQCh. 14 - Prob. 37RQCh. 14 - Prob. 38RQCh. 14 - Prob. 39RQCh. 14 - Prob. 40RQCh. 14 - Prob. 41RQCh. 14 - Prob. 42RQCh. 14 - Prob. 43RQCh. 14 - Prob. 44RQCh. 14 - Prob. 45RQCh. 14 - Prob. 46RQCh. 14 - Prob. 47RQCh. 14 - Prob. 1DQCh. 14 - What issues are accountants concerned with when...Ch. 14 - What documentation techniques are used in the...Ch. 14 - Compare and contrast the structured design...Ch. 14 - Prob. 5DQCh. 14 - Explain how benchmarking works. Should this be...Ch. 14 - Discuss the importance of the weights assigned to...Ch. 14 - Who should select the contact user groupthe vendor...Ch. 14 - What processes should be used to develop useful...Ch. 14 - Prob. 10DQCh. 14 - Prob. 11DQCh. 14 - Prob. 12DQCh. 14 - A good structure diagram should be loosely coupled...Ch. 14 - Prob. 14DQCh. 14 - Prob. 15DQCh. 14 - Prob. 16DQCh. 14 - Prob. 17DQCh. 14 - Prob. 18DQCh. 14 - What are the three implementation (cutover)...Ch. 14 - Prob. 20DQCh. 14 - Discuss the importance of involving accountants in...Ch. 14 - Prob. 1MCQCh. 14 - Prob. 2MCQCh. 14 - Prob. 3MCQCh. 14 - Prob. 4MCQCh. 14 - Prob. 5MCQCh. 14 - Prob. 6MCQCh. 14 - Prob. 7MCQCh. 14 - Prob. 8MCQCh. 14 - Prob. 9MCQCh. 14 - Prob. 10MCQCh. 14 - Prob. 11MCQCh. 14 - Prob. 12MCQCh. 14 - Prob. 1PCh. 14 - Prob. 2PCh. 14 - Prob. 3PCh. 14 - Prob. 4PCh. 14 - Prob. 5PCh. 14 - Prob. 6PCh. 14 - Prob. 7PCh. 14 - Prob. 8PCh. 14 - Prob. 9PCh. 14 - Prob. 10PCh. 14 - Prob. 11PCh. 14 - Prob. 12PCh. 14 - Prob. 13PCh. 14 - Prob. 14P
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
- 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…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_forwardSales ledger control Account is known to have a debit balance. Explain, using numerical example why at certain instances the account has both debit and credit balance brought down? Construct a Purchase Ledger Control Account, using your own numerical example, with five items? Briefly discuss the role of the control accounts in the identification of missing figures in the financial statements of organizations ?arrow_forward
- 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…arrow_forwardRequired: A sales invoice typically includes the date of sale, salesperson, customer data, items included in the sale, and amount. Which foreign keys should be added to the following table to link all of these data elements? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) Sales Table Invoice# Date Amount S-101 10/05/2021 2549.90 S-105 11/01/2021 949.95 S-107 11/02/2021 1209.70 S-108 11/06/2021 699.90 ?Salesperson # ? Customer # ? Receipt # ? Inventory # ? Remittance Advice # ? Sales # ?Cashier # ?Casharrow_forwardAll of the following are examples of sales order entry system controls except? Digital signatures/written signatures Credit Limits Approving invoices before paying Trainingarrow_forward
- Describe the data flow in the buying process that begins when the purchasing organization sends a check to a vendor to settle an invoice for goods bought.arrow_forwardA company is trying to set up proper internal controls for their accounts payable/inventory purchasing system. Currently the purchase order is generated by the same person who receives the inventory. Together the purchase order and the receiving ticket are sent to accounts payable for payment. What changes would you make to improve the internal control structure? Group of answer choices 1.The person in accounts payable should generate the purchase order. 2.The person in accounts payable should generate the receiving ticket once the invoice from the supplier is received. 3.No changes would be made since the person paying the bills is different from the person ordering the inventory. 4.The responsibilities of generating the purchase order and receiving the inventory should be separated among two different people.arrow_forwardWhich of the following are examples of preventive controls? Select all that apply. O account coding on purchase orders is checked by the computer using a table of valid account numbers computerized accounting system will not allow a sale to be processed if a customer has exceeded its credit limit O quarterly review of credit balances in accounts receivable for reasonableness O sales manager reviews daily shipments, total sales, and sales per unit shipped O sales invoices are priced automatically using a master pricing filearrow_forward
- 12.1 Match the term in the left column with its definition in the right column. 1. CRM system a. Document used to authorize reducing the balance in a customer account 2. Open-invoice method b. Process of dividing customer account master file into subsets and preparing invoices for one subset at a time 3. Credit memo C. System that integrates EFT and EDI information 4. Credit limit d. System that contains customer-related data organized in a manner to facilitate customer service, sales, and retention 5. Cycle billing e. Electronic transfer of funds 6. FEDI f. Method of maintaining accounts receivable that generates one payment for all sales made the previous montharrow_forwardCompare and contrast a manual accounting system with a computerized accounting system for process vendors transactions. What uses are there for using tje vendor balance summary and AP aging summary reports? Explain why the balance in merchandise inventory different than in accounts payable? Be sure to include at least one reference from an online resource.arrow_forwardSpeeDIY Sdn. Bhd. is an online Do-It-Yourself (DIY) store located in Sintok that provides home delivery of DIY products purchased via the Internet. SpeeDIY uses a fully integrated accounting system and practices automated Economic Order Quantity (EOQ) model in managing its inventory. For each registered item in the inventory database, the system specifies quantity on hand and a desired quantity on hand. When the quantity on hand falls below the desired quantity on hand, a notification automatically pops up on the purchasing clerk's computer screen, alerting the clerk to reorder the item. The purchasing clerk can proceed with the reordering of items simply by checking the acceptance box. When the acceptance box is checked, the purchase order transaction file is created. In addition, the vendor is notified electronically through a transmission from the purchasing system. The purchasing clerk prepares a purchase summary report to his manager at the end of the day. SpeeDIY warehouse has…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,Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher: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