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 9, Problem 9P
To determine
Develop normalized data tables in third normal form. Also, mention the steps necessary to normalized the report and establish link between tables.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
A table of data for a library is shown in the table. Normalize these data into the third normal form, preparing it for use in a relational database environment. The library’s computer is programmed to compute the due date to be 14 days after the checkout date. Document the steps necessary to normalize the data similar to the procedures found in the chapter. Index any fields necessary and show how the databases are related.
Select the letter of the item below that best matches the definitions that follow.
a. Data Files CD ________
b. Lists ________
c. Forms ________
d. Registers ________
e. Reports and graphs ________
f. Restoring a backup ________
g. Icon bar ________
h. Home page ________
i. Backing up a file ________
1. One click access to QuickBooks Accountant Centers and Home page.
2. The process of rebuilding a backup file to a full QuickBooks Accountant file ready for additional input.
3. Electronic representations of paper documents used to record business activities such as customer invoices, vendor bills, and checks.
4. A big-picture approach of how your essential business tasks fit together organized by logical groups such as customers, vendors, and employees.
5. Groups of names such as customers, vendors, employees, items, and accounts.
6. Contains backups of all the practice files needed for chapter work and completion of assignments.
7. The process of creating a copy of a…
Most computerized accounting systems use electronic forms to record transaction information, such as the invoice form illustrated at the top of Exhibit 7 in this chapter.a. Identify the key input fields (spaces) in an electronic invoice form.b. What accounts are posted from an electronic invoice form?c. Why aren’t special journal totals posted to control accounts at the end of the month in an electronic accounting system?
Chapter 9 Solutions
Accounting Information Systems
Ch. 9 - Prob. 1RQCh. 9 - Prob. 2RQCh. 9 - Prob. 3RQCh. 9 - Prob. 4RQCh. 9 - Prob. 5RQCh. 9 - Prob. 6RQCh. 9 - Prob. 7RQCh. 9 - Prob. 8RQCh. 9 - Prob. 9RQCh. 9 - Prob. 10RQ
Ch. 9 - Prob. 11RQCh. 9 - Prob. 12RQCh. 9 - Prob. 13RQCh. 9 - Prob. 14RQCh. 9 - Prob. 15RQCh. 9 - Prob. 16RQCh. 9 - Prob. 17RQCh. 9 - What are the conditions for third normal form...Ch. 9 - Prob. 19RQCh. 9 - Prob. 20RQCh. 9 - Prob. 21RQCh. 9 - What is a user view?Ch. 9 - Prob. 23RQCh. 9 - Prob. 24RQCh. 9 - Prob. 25RQCh. 9 - Prob. 1DQCh. 9 - Prob. 2DQCh. 9 - Prob. 3DQCh. 9 - Prob. 4DQCh. 9 - Prob. 5DQCh. 9 - Prob. 6DQCh. 9 - Prob. 7DQCh. 9 - Prob. 8DQCh. 9 - Prob. 9DQCh. 9 - Prob. 10DQCh. 9 - Prob. 11DQCh. 9 - Prob. 12DQCh. 9 - Prob. 13DQCh. 9 - Prob. 14DQCh. 9 - Prob. 15DQCh. 9 - Discuss the accounting implications of the update,...Ch. 9 - Prob. 17DQCh. 9 - Prob. 18DQCh. 9 - Prob. 19DQCh. 9 - Prob. 20DQCh. 9 - Prob. 1MCQCh. 9 - Prob. 2MCQCh. 9 - Prob. 3MCQCh. 9 - Prob. 4MCQCh. 9 - Prob. 5MCQCh. 9 - Prob. 6MCQCh. 9 - Prob. 7MCQCh. 9 - Prob. 8MCQCh. 9 - Prob. 9MCQCh. 9 - Prob. 10MCQCh. 9 - Prob. 11MCQCh. 9 - Prob. 12MCQCh. 9 - Prob. 13MCQCh. 9 - Prob. 14MCQCh. 9 - Prob. 15MCQCh. 9 - Prob. 16MCQCh. 9 - Prob. 17MCQCh. 9 - Prob. 18MCQCh. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - Prob. 2PCh. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Prob. 4PCh. 9 - Prob. 5PCh. 9 - Prob. 6PCh. 9 - Prob. 7PCh. 9 - Prob. 8PCh. 9 - Prob. 9PCh. 9 - Prob. 10PCh. 9 - Prob. 11PCh. 9 - Prob. 12PCh. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Prob. 14PCh. 9 - Prob. 15PCh. 9 - Prob. 16PCh. 9 - Prob. 17PCh. 9 - Prob. 18PCh. 9 - Prob. 21PCh. 9 - Prob. 22PCh. 9 - Prob. 23PCh. 9 - Prob. 24P
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
- The accounting clerk for the Ram System company receives source documents such as purchase orders, sales invoices, and vendor invoices, which she uses to prepare journal vouchers to the general ledger for general ledger entries. Each day the clerk posts the journal vouchers to the general ledger and the related subsidiary ledgers. Each month the clerk reconciles the subsidiary accounts to their control accounts in the general ledger to ensure that they balance. Required: Discuss any control weaknesses and risks associated with this scenario.arrow_forwardAll of the following can provide source data except ________. A. a scanning device at the grocery store B. a utility bill received in the mail C. a bar code reader D. software to process the source dataarrow_forwardThe sales department receives the unstandardised sales order since customer orders are mailed, e-mailed or faxed to the sales department. The sales clerk first converts the unstandardised sales order into the standardised sales order. For this purpose, the sales representative requests the missing information, if any. When the order is received, the sales clerk checks the customer’s creditworthiness of the customer from his computer terminal. Three years ago, the sales clerk requested the accounting department to provide him with a list of customers whose account receivables are written off. The sales clerk is still using this information to check the creditworthiness of the customers. The sales clerk is using the same procedure to check the creditworthiness of the new customers.The customer’s order is rejected if the customer’s credit is not verified. The sales order processing is started after the credit verification. In particular, the sales clerk records the approved standardised…arrow_forward
- The sales department receives the unstandardised sales order since customer orders are mailed, e-mailed or faxed to the sales department. The sales clerk first converts the unstandardised sales order into the standardised sales order. For this purpose, the sales representative requests the missing information, if any. When the order is received, the sales clerk checks the customer’s creditworthiness of the customer from his computer terminal. Three years ago, the sales clerk requested the accounting department to provide him with a list of customers whose account receivables are written off. The sales clerk is still using this information to check the creditworthiness of the customers. The sales clerk is using the same procedure to check the creditworthiness of the new customers.The customer’s order is rejected if the customer’s credit is not verified. The sales order processing is started after the credit verification. In particular, the sales clerk records the approved standardised…arrow_forwardTwo features of internal control are presented in the following sections. Each is followed by a list of four irregularities that occurred in processing data. Identify the one irregularity from each list that would be discovered or prevented by the feature of internal control described. a. The sum of the balances of the accounts in the customer's ledger is compared at the end of each month with the balance of the accounts receivable account in the general ledger by a person who has no responsibility for maintaining either the general ledger or the customers ledger. Five hours of services were rendered but the customer was only billed for four hours. A cash receipt of $750 was recorded correctly in the accounts receivable controlling account but was posted to the customer's ledger as $75. A bill for services rendered to Cole Co. was erroneously posted to the account of Coleman Co. in the customer's ledger. No entry was made in the accounting records for services rendered to a customer.…arrow_forwardLamar LLC is in the process of updating its revenues and receivables systems with the implementation of new accounting software. James Loden, Inc. is an independent information technology consultant who is assisting Tamar with the project. James has developed the following checklist containing internal control points that the company should consider in this new implementation: Will customer orders be received via the Internet? Are all collections from customers received in the form of checks? Are product quantities monitored regularly?arrow_forward
- Janice Dodds opens the mail for the Ajax Plumbing Company. She lists all customer checks on a spreadsheetthat includes the name of the customer and the check amount. The checks, along with the spreadsheet, are thensent to Jim Seymour in the accounting department who records the checks and deposits them daily in the company’s checking account. How could the company improve its internal control procedure for the handling of itscash receipts?arrow_forwardRichard Palm is the accounting clerk of Olive Limited. He uses the source documents such as purchase orders, sales invoices, and suppliers’ invoices to prepare journal vouchers for general ledger entries. Each day he posts the journal vouchers to the general ledger and the related subsidiary ledgers. At the end of each month, he reconciles the subsidiary accounts to their control accounts in the general ledger to ensure they balance. Discuss the internal control weaknesses and risks associated with the above process. (maximum 300 words)arrow_forwarddraw the system flow chart for the following narrative? Cornick, Inc. sells office products to businesses in the eastern region of the United States. Each month, the IT division at Cornick prints monthly statements and sends them to the accounts receivable (AR) department, where a clerk mails them to the customers. Cornick’s custo- mers mail their payments back to Cornick, where a clerk in AR batches the checks and sends them to the cashier. The AR clerk then uses the payment stub to enter the payments into the computer, where the AR master data are updated to record the paymentarrow_forward
- Draw the flow chart for the following - manual based(NOTE: add files, data store and departments which all time should be included even not in the following process, also don’t add any more process not in the scenario , your drawing should be clear )The Process: Vendors send invoices to the AP department where they are reviewed and approved for payment. Once approved, the invoice and a cash disbursement voucher are sent to the cash disbursement department, where a check is prepared and sent to the vendor. A copy of the check, the invoice, and the voucher are returned to the AP department and filed.arrow_forwardThe following are internal controls that theauditor has identified for various cycles.1. Sales invoices are matched with shipping documents and customer orders beforerecording in the sales journal.2. Receiving reports are prenumbered and accounted for on a daily basis.3. Sales invoices are independently verified before being sent to customers.4. Payments by check are received in the mail by the receptionist, who lists the checksand restrictively endorses them.5. Overtime hours for payroll are approved by the employee’s supervisor.6. Checks are signed by the company president, who compares the checks with theunderlying supporting documents.7. Unmatched shipping documents are accounted for on a daily basis.8. All payroll payments must have a valid employee identification number assigned bythe human resources department at the time of hiring.9. The accounts receivable master is reconciled to the general ledger on a monthly basis.a. For each internal control, identify the type(s) of…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
College 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 Pub
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
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
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning