Please complete the following homework assignment:
- Problem 3.2
- 3.2. The Happy Valley Utility Company uses turnaround documents in its computerized customer accounting system. Meter readers are provided with preprinted computer forms, each containing the account number, name, address, and previous meter readings. Each form also contains a formatted area in which the customer’s current meter reading can be marked in pencil. After making their rounds, meter readers turn in batches of these documents to the computer data preparation department, where they are processed by a mark-sense document reader that transfers their contents to magnetic tape.
- This magnetic tape file is used as input for two computer runs. The first run sorts the transaction records on the tape into sequential order by customer account number. On the second run, the sorted transaction tape is processed against the customer master file, which is stored on a magnetic disk. Second-run outputs are (1) a printed report listing summary information and any erroneous transactions detected by the computer and (2) customer bills printed in a special OCR-readable font. Bills are mailed, and customers are requested to return the stub portion along with payment.
- Customer payments are received in the mailroom and checked for consistency against the returned remittance stubs. Checks are then sent to the cashier’s office. The mailroom provides the computer data preparation department with three sets of records: (1) stubs with compatible amounts, (2) stubs with differing amounts, and (3) a list of amounts received from customers, without stubs. For the latter two types of records, data preparation personnel use a special off-line keying device to prepare corrected stubs. An OCR document reader reads all the stubs and sends the data to the company’s computer. The computer updates the customer master file to post the payment amounts. Two printed outputs from this second process are (1) reports listing erroneous transactions and summary information and (2) past-due customer balances.
- a. Draw a system flowchart of the billing operations, commencing with the computer preparation of the meter reading forms and ending with the mailing of customer bills.
- b. Draw a system flowchart depicting customer payments processing, starting with the mailroom operations and ending with the two printed reports.
- (Romney 65-66)
- Romney, Marshall B., Paul Steinbart. Accounting Information Systems, 12th Edition. Pearson Learning Solutions, 1/2011. VitalBook file.
4.1. The following data elements comprise the conceptual-level schema for a database:
quantity on hand
a. Identify three potential users and design a subschema for each. Justify your design by explaining why each user needs access to the subschema data elements.
b. Use Microsoft Access or some other relational database product to create the schema tables. Specify the primary key(s), foreign key(s), and other data for each table. Test your model by entering sample data in each table.
Romney, Marshall B., Paul Steinbart. Accounting Information Systems, 12th Edition. Pearson Learning Solutions, 1/2011. VitalBook file.