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 4, Problem 6P
Summary Introduction
Narrative summary:
Company G sells consumer products online. The website will consist of front-end web server that helps for the interaction of customer and back-end server. The narrative further explains the activities involved in the process of receiving the order to delivering the order.
To draw: A physical data flow diagram.
Introduction:
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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…
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…
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?
Chapter 4 Solutions
Accounting Information Systems
Ch. 4 - Prob. 1RQCh. 4 - Prob. 2RQCh. 4 - Describe each symbol used in constructing DFDs.Ch. 4 - Prob. 4RQCh. 4 - Prob. 5RQCh. 4 - Prob. 6RQCh. 4 - What is a logical DFD?Ch. 4 - Prob. 8RQCh. 4 - When is a set of DFDs balanced (i.e., leveled)?Ch. 4 - Prob. 10RQ
Ch. 4 - Prob. 11RQCh. 4 - Prob. 12RQCh. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Prob. 15RQCh. 4 - Prob. 16RQCh. 4 - How will systems documentation differ between...Ch. 4 - Prob. 1DQCh. 4 - Prob. 2DQCh. 4 - Prob. 3DQCh. 4 - Prob. 1SPCh. 4 - Prob. 2SPCh. 4 - Narrative 1: Freshplace Grocery At Freshplace...Ch. 4 - Prob. 4SPCh. 4 - Narrative 1: Freshplace Grocery At Freshplace...Ch. 4 - Prob. 6SPCh. 4 - Prob. 1PCh. 4 - Prepare a narrative to describe the system...Ch. 4 - Prob. 3PCh. 4 - Narrative 1: Good Buy, Inc (good-buy.com) Good...Ch. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Narrative 1: Good Buy, Inc (good-buy.com) Good...Ch. 4 - Prob. 8P
Knowledge Booster
Similar questions
- Good Buy, Inc. (good-buy.com) Good Buy, Inc. (a fictitious company) sells a variety of consumer products through its Web site, good-buy.com. Good Buys IT infrastructure consists of a front-end Web server that interacts with customers and a back-end ERP system that manages the inventory and performs other typical ERP functions. The sales order process begins when a customer logs on to the good-buy.com Web site. The Web server requests the current Good Buy online catalog from the ERP system, which sends the catalog to the Web server, and the server displays it to the customer. The customer selects the items and quantities that he wants to purchase; the Web server edits the customer input for accuracy (e.g., ensures that all required fields have been selected or filled in) and sends this list on to the ERP system, where the requested quantities of inventory are allocated for the sale. The ERP sends back to the Web server the quantities that have been allocated, and the Web server displays this information on the customers screen. The customer verifies that the order is correct and completes the sale by entering his shipping and credit card information. The Web server edits this data for accuracy (e.g., ensures that all required fields have been selected or filled in and that the length of the entered credit card number is correct) and sends the credit card information and amount of the sale on to the credit card company. The credit card company sends back a verification number, and the Web server notifies the customer that the sale has been completed by displaying a confirmation number on the customers screen. The Web server also notifies the ERP system that the sale has been completed, and the ERP system changes the status of the inventory from allocated to sold, prints a picking ticket or packing slip in the warehouse, and records (on the enterprise database) a sale and an account receivable from the credit card company. a. Prepare a table of entities and activities for Good Buy, Inc. or CentralRisk Insurance Company. b. Construct a context diagram based on the table you prepared in part (a). Use Microsoft Visio or other diagraming software.arrow_forwardNarrative 1: Good Buy, Inc (good-buy.com) Good Buy, Inc. (a fictitious company) sells a variety of consumer pro-ducts through its Web site, good-buy.com. Good Buy's IT infrastructure consists of a front-end Web server that interacts with customers and a back-end ERP system that manages the inventory and performs other typical ERP functions. The sales order process begins when a customer logs an to the good-buy.00m Web site. The customer requests the company catalog and the Web server obtains the current Good Buy online catalog fmm the ERP system, which sends the catalog to the Web server, and the server displays it to the customer. The customer selects the items and quantities that he or the wants to purchase; the Web server edits the customer input for accuracy (e.g, ensures that all required fields have been selected or frilled in) and sends this list on to the ERP system, where the requested quantities of inventory are allocated for the sale. The ERP sends back to the Web server the quantities that have been allocated, and the Web serverdisplays this information on the customer's semen. The customer verifies that the order is correct and completes the sale by entering his or her shipping and credit card information. The Web server edits this data for accuracy (e.g, enmra that all required fields have been selected or filled in and that the length of the entered credit card number is correct) and sends the credit card information and amount of the sale on to the credit card company. The credit card company sends back a verification number, and the Web server notifies the customer that the sale has been completed by displaying a confirmation number on the customer's screen. The Web server also notifies the ERP system that the sale has been completed, and the ERP system changes the status of the inventory from allocated to sold, prints a pick-ing ticket or packing slip in the warehouse, and records (on the enterprise database) a sale and an account receivable from the credit card company. Use the narrative(s) as selected by your instructor, to prepare a table of entities and activities.arrow_forwardNarrative 1: Good Buy, Inc (good-buy.com) Good Buy, Inc. (a fictitious company) sells a variety of consumer pro-ducts through its Web site, good-buy.com. Good Buy's IT infrastructure consists of a front-end Web server that interacts with customers and a back-end ERP system that manages the inventory and performs other typical ERP functions. The sales order process begins when a customer logs an to the good-buy.00m Web site. The customer requests the company catalog and the Web server obtains the current Good Buy online catalog fmm the ERP system, which sends the catalog to the Web server, and the server displays it to the customer. The customer selects the items and quantities that he or the wants to purchase; the Web server edits the customer input for accuracy (e.g, ensures that all required fields have been selected or frilled in) and sends this list on to the ERP system, where the requested quantities of inventory are allocated for the sale. The ERP sends back to the Web server the quantities that have been allocated, and the Web serverdisplays this information on the customer's semen. The customer verifies that the order is correct and completes the sale by entering his or her shipping and credit card information. The Web server edits this data for accuracy (e.g, enmra that all required fields have been selected or filled in and that the length of the entered credit card number is correct) and sends the credit card information and amount of the sale on to the credit card company. The credit card company sends back a verification number, and the Web server notifies the customer that the sale has been completed by displaying a confirmation number on the customer's screen. The Web server also notifies the ERP system that the sale has been completed, and the ERP system changes the status of the inventory from allocated to sold, prints a picking ticket or packing slip in the warehouse, and records (on the enterprise database) a sale and an account receivable from the credit card company. Use the narrative(s) as selected by your instructor, to prepare a table of entities and activities. Annotate the table of entities and activities to indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing a level 0 logical DFD. Prepare a logical DFD (level 0 only) based on the table you prepared. If you completed any of the previous problems, use that information to help you construct the diagram. a. Use Microsoft Visio, any other diagramming software or another Microsoft office product such as Excel to create the diagram you drew in SP 4-7.arrow_forward
- ABC Company is using the inventory system managed by the vendor. The product is owned and managed by the vendor until it is delivered from ABC's distribution center to the stores. What do you think will be the problems that ABC will encounter in its purchases and payments process?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
- 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_forwardIf one of NetSolution's customers returns some merchandise that had been purchased on account (accounts receivable), NetSolutions will inform the customer that the return has been authorized as indicated by a _______ memo. Group of answer choices credit memo debit memo sales return memo sales memoarrow_forwardThe following is a description of manufacturing com-pany’s purchasing procedures. All computers in the com-pany are networked to a centralized accounting system sothat each terminal has full access to a common database.The inventory control clerk periodically checks in-ventory levels from a computer terminal to identifyitems that need to be ordered. Once the clerk feels in-ventory is too low, he chooses a supplier and creates apurchase order from the terminal by adding a record tothe purchase order file. The clerk prints a hard copy ofthe purchase order and mails it to the vendor. An elec-tronic notification is also sent to accounts payable andreceiving, giving the clerks of each department accessto the purchase order from their respective terminals.When the raw materials arrive at the unloading dock,a receiving clerk prints a copy of the purchase orderfrom his terminal and reconciles it to the packing slip.The clerk then creates a receiving report on a computersystem. An electronic…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Accounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage LearningPkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LAuditing: 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 SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
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 to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,