Question
Sunnyvale Electrical. sells electrical parts to electrical contractors in the southeastern United States. Sunnyvale Electrical customers mail their paymentsattached to the stub (i.e., remittance advice
Sunnyvale Electrical. sells electrical parts to electrical contractors in the southeastern United States. Sunnyvale Electrical customers mail their paymentsattached to the stub (i.e., remittance advice [RA]) from their monthly statementto Sunnyvale 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 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. Please refer to chapter 11 and 4 for help in the diagrams and tables.Please use word or excel for the diagrams.
Problem 1 draw a table of entities and activities 20 points
Problem 2 draw a context diagram 20points
Problem 3 make an annotated table of entities and activities. Indicate on this table the groupings, bubble numbers, and bubble titles, to be used in preparing a level 0 logical DFD. 20 points
Problem 4 Draw a level 0 logical DFD. 20 points
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started