Question: Textbook Assignment 2: Complete Problem 11-1 (All parts a through e). In order to complete the problems, use Case A AAA Electrical, Inc. (Cash Receipts

Textbook Assignment 2:

Complete Problem 11-1 (All parts a through e).

In order to complete the problems, use Case A AAA Electrical, Inc. (Cash Receipts Process).

Case A: AAA Electrical, Inc. (Cash Receipts Process)

AAA Electrical, Inc sells electrical parts to electrical contractors in the southeastern United States. AAA Electrical customers mail their payments - attached to the stub (i.e. remittance advice [RA]) from their monthly statement - to AAA Electrical accounts receivable (AR) office. An AR clerk confirms that the check amount agrees with the amount on the RA and sends the checks to the cashier. The AR clerk prepares batch totals of the customer numbers, invoice numbers, and the amount paid. The AR clerk then enters the batch totals and RAs into the computer, where the AR master data are updated to record the payment. The computer reconciles the batch totals, confirms job completion, and reports discrepancies, if any, to the AR clerk.

Use the information from the above case to complete the following:

(a) Prepare a table of entities and activities. (Note, there should be 4 entities and 9 activities. Be sure to correctly label/format each)

(b) Draw a context diagram. (Note, there should be 2 squares, 1 circle, and 2 connecting lines. Be sure to correctly label/format each)

(c) Draw a physical data flow diagram (DFD). (Note, there should be 2 squares, 2 circles, 6 connecting lines and 1 data master component. Be sure to correctly label/format each)

(d) Prepare an annotated table of entities and activities. Indicate on the table the groupings, bubble numbers, and bubble titles to be used in preparing a level 0 logical DFD. (Note, there should be 4 columns, 2 entities, 6 activities, and 2 processes. Be sure to correctly label/format each)

(e) Draw a level 0 logical DFD. (Note, there should be 2 squares, 2 circles, 6 connecting lines, and 1 data master component. Be sure to correctly label/format each)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!