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…
Create a flowchart for the following telephone-ordering process at a retail chain that specializes in selling books and music CDs.
It provides an ordering system via the telephone to its time-sensitive customers besides its regular store sales.
The automated system greets customers, asks them to choose a tone or pulse phone, and routes them accordingly.
The system checks to see whether customers have an existing account.
They can wait for the service representative to open a new account.
Customers choose between order options and are routed accordingly.
Customers can cancel the order.
Finally, the system asks whether the customer has additional requests; if not, the process terminates.
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 an annotated table of entities and activities based on the output from Problems 4-4 and 4-5. Indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing a level 0 logical DFD. b. Prepare a logical DFD (level 0 only) 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
- Required: 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_forward12.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_forward
- Create a flowchart for the following telephone-ordering process at a retail chain that specializes in selling books and music CDs. It provides an ordering system via the telephone to its time-sensitive customersbesides its regular store sales. First, the automated system greets customers and identifies whether they have a tone or pulse phone. Customers choose 1 if they have a tone phone; otherwise, they wait for the first available service representative to process their request. If customers have a tone phone, they complete their request by choosing options on the phone. First, the system checks to see whether customers have an existing account.Customers choose 1 if they have an existing account or choose 2 if they want to open a new account. Customers wait for the service representative to open a new account if they choose 2. Next, customers choose between the options of making an order, canceling an order, or talking to a customer representative for questions and/or complaints. If…arrow_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
- The 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_forwardWhen 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_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
arrow_back_ios
SEE MORE QUESTIONS
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 LCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, 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 PubAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
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
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, 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
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College