978-1133934400 Chapter 2 Solution Manual Part 5

subject Type Homework Help
subject Pages 9
subject Words 588
subject Authors James A. Hall

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
17. SYSTEM DOCUMENTATION EXPENDITURE CYCLE
Chapter 2 Page 37
Chapter 2 Page 38
18.
Soluon to Problem 2-18 – Cash Receipts Centralized DP System
Chapter 2 Page 39
19.
Solution to Problem 2-19 Purchases System Centralized Data Processing
Chapter 2 Page 40
20. SYSTEM DOCUMENTATION CASH DISBURSEMENT
page-pf6
Chapter 2 Page 41
21. CODING SCHEME
101.0 Cash
102.0 Accounts Receivable
103.0 Office Supplies Inventory
104.0 Prepaid Insurance
105.0 Inventory
page-pf7
Chapter 2 Page 42
302.0 Paid in Capital in Excess of Par
311.0 Treasury Stock
390.0 Retained Earnings
401.0 Sales
401.5 Sales Returns and Allowances
22. CODING SCHEME
Warehouse Aisle
Left or right
Side of Aisle Shelf Bin
1 C L 5 08
page-pf8
Chapter 2 Page 43
23. FLAT FILE VS DATABASE MODEL
The problems with flat files that are resolved by Database technology include:
Data Storage --- Flat files result in considerable data redundancy and storage problems
Data Updating -- When users keep separate files, all changes must be made separately for
each user. This adds significantly to the task and the cost of data management.
24. ACCESS METHODS
page-pf9
Chapter 2 Page 44
a. indexed sequential or indexed random; least optimal: sequential
b. indexed random or hashing; least optimal: sequential
c. sequential; least optimal: indexed random
25. FILE ORGANIZATION
b. Random access for customer balances and payment information is crucial. A network or
relational database is necessary since this is a many-to-many relationship: many
c. Random access will be necessary for flight inquiries and updates throughout the day. A
navigational database would be appropriate. Only one direction needs to be
investigated. Most customers start with a departure city and then flights to the
d. A random access storage device is necessary to access the students’ records quickly
when they check out books. A network or relational database will be necessary since the
page-pfa
Chapter 2 Page 45

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.