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.
In a computer system, how are accounting records posted?a. master file is updated to a transaction fileb. master file is updated to an index filec. transaction file is updated to a master filed. master file is updated to a year-to-date filee. current balance file is updated to an index file
All of the following can provide source data except ________.A. a scanning device at the grocery storeB. a utility bill received in the mailC. a bar code readerD. software to process the source data
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
- All 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_forwardurnalizing entries, information can be entered into T-Accounts and/or the four-column ledger. Enter the information from the T-Account and calculate the running balance in the appropriate place in the four-column ledger to review the similarities between the two formats.arrow_forwardMatch each example with a component of a computerized accounting information system. Components may be used more than once. Example Component 1. Server 2. Bank checks 3. Reports 4. Keyboard 5. Software 6. Financial statements 7. Bar code scannerarrow_forward
- In June 2021, Chan Lee opened a photography studio that provides services to public and private schools. His firm's Chart of Accounts and financial activities for the first month of operations appear below: Chan Lee Photography Studio Chart of Accounts ASSETS REVENUE 101 Cash 404 Service Fees 111 Accounts Receivable EXPENSES Rent Expense Salaries Expense Telephone Expense Utilities Expense Miscellaneous Expense Supplies Office Furniture 121 511 141 512 Office Equipment Photographic Equipment LIABILITIES 142 513 151 514 531 202 Accounts Payable OWNER’S EQUITY Chan Lee, Capital Chan Lee, Drawing 301 302 Date Transactions June 1 Chan Lee invested P300,000 cash in the business. 2 Issued Check # 1001 for P30,000 to pay the June rent. 5 Purchased desks and other office furniture for P50,000 from Office Plus; received Invoice # 5312, payable in 60 days. 6 Issued Check # 1002 for P150,000 to purchase photographic equipment. 7 Purchased photography supplies for P40,000, paid with Check # 1003.…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 systems programmer uses a hashing algorithm to determine storage addresses. The hashing structure is 9,997/key. The resulting number is then used to locate the record. The first two digits after the decimal point represent the cylinder number, while the second two digits represent the surface number. The fifth, sixth, and seventh digits after the decimal point represent therecord number. This algorithm results in a unique address 99 percent of the time. What happens the remainder of the time when the results of the algorithm are not unique? Explain in detail the storage process when key value 3 is processed first, key value 2307 at a later date, and shortly thereafter key value 39.arrow_forward
- For each of the following file processing operations, indicate whether a sequential file, indexed random file, indexed sequential access method (ISAM), hashing, or pointer structure works the best. You may choose as many as you wish for each step. Also, indicate which would perform the least optimally.a. Retrieve a record from the file based upon its primary key value.b. Update a record in the file.c. Read a complete file of records.d. Find the next record in a file.e. Insert a record into a file.f. Delete a record from a file.g. Scan a file for records with secondary keys.arrow_forwardFor each of the following file processing operations, indicate whether a sequential file, indexed random file, virtual storage access method, hashing, or pointer structure would work best. You may choose as many as you wish for each step. Also indicate which would perform the least optimally. a. Retrieve a record from the file based on its primary key value. b. Update a record in the file. c. Read a complete file of records. d. Find the next record in a file. e. Insert a record into a file. f. Delete a record from a file. g. Scan a file for records with secondary keys.arrow_forwardCan you do proper formatting, if you use a table or or excel for the spreadsheet, attach proper image. I have attached an image on how the table should look like. Also properly format the journal entries, make it easier to understand what is debit what is credit and the dates.arrow_forward
- identify and discuss the steps in the recording process. Be sure to discuss what each step does and how it relates to the steps before and after it. Then, answer the following questions: Should business transactions credits and debits be recorded directly into the ledger accounts? What are the advantages of recording in the journal before posting transactions into the ledger?arrow_forward________ takes all transactions from the journal during a period and moves the information to a general ledger (ledger). A. Hitching B. Posting C. Vetting D. Laxingarrow_forwardAll records in a file must have a unique way of identifying a particular record within that file, normally referred to as a primary key. Based on your general knowledge of accounting, for each of the following types of accounting records, indicate what the most likely primary key would be to access records within that file. REQUIRED: Using the attached answer sheet, indicate the primary key that would be used to access the file for the list of files provided below. Explain your answer where appropriate. LIST OF ACCOUNTING FILES NEEDED TO BE ACCESSED WITH PRIMARY KEY Accounting File Accounts Receivable (a) (b) Accounts Payable (c) Inventory (d) Customer Sales Order (e) Purchase Orders (f) Cash Receipts From Customers (g) Payroll Earnings For Employee (h) General Ledger Primary Keyarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
- Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College PubAuditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher: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
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
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College