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