Your company needs a program to process the company's payroll. The timeclock records are in one file named timeclock.txt and your HR department has provided you with a file named personnel.txt$.$

$*****$Instructions$****$

Please pay attention I only need A diagram of the solution and a Pseudocode of the solution. This is important $****$ Provide a clear hand$-$drawing Diagram for this assignment$***$

$******$Design

$1.$ A diagram of the solution

$2.$ Pseudocode of the solution

Implementation

Create a python program that demonstrates reading and comparing multiple files, processes the input files based on the business rules, and produces an output file.

Needed Files

The timeclock.txt darr file contains the hours worked data for every employee as well as the shift they worked. The layout for the file is as follows:

EMPLOYEE$\_$NUMBER, HOURS$\_$WORKED, SHIFT

The personnel.txt darr file contains the names of all employees and their hourly pay rates. The layout for the file is as follows:

EMPLOYEE$\_$NUMBER, EMPLOYEE$\_$NAME, PAY$\_$RATE

Note: Both the timeclock.txt and payroll.txt files are pre$-$sorted by EMPLOYEE$\_$NUMBER in ascending order.

Business Rules

For hours the employee gross pay is: HOURS$\_$WORKED $*$ PAY$\_$RATE

For hours $>40,$ the employee gross pay is: HOURS$\_$WORKED $*$ PAY$\_$RATE $*1\mathrm{.}5$

For shift $3,$ add $$1$ per hour to the employee pay rate

The program should:

Download both input files in the same folder that you will create your $.$py program.

Read both input files together.

Match the input files by the EMPLOYEE NUMBER.

For each record in the timesheet.txt file, write a record in a new output file named payroll.txt based on the business rules provided. The layout for payroll.txt is as follows:

EMPLOYEE$\_$NUMBER, EMPLOYEE$\_$NAME, GROSS$\_$PAY

Document your program with appropriate comments. Remember if you worked in teams, all team members' names must be in the comments.

to payroll$1.$txt$,$ payroll$2.$txt$,$ etc.

timeclock.txt

$22476,45,3$

$24987,30,1$

$48283,50,2$

$85437,25,3$

personnel.txt

$11235,$ Bob Smith,$10\mathrm{.}50$

$22476,$ Jhon Roberts, $12\mathrm{.}35$

$24987,$ Mary Jhonson, $15\mathrm{.}90$

$32743,$ Brad Carson, $11\mathrm{.}25$

$48283,$ Alic martin, $14\mathrm{.}20$

$85437,$ Aaron James, $15\mathrm{.}15$

expectedpayroll.txt

$22476,$ john Roberts, $634\mathrm{.}12$

$24987,$ mary johnson, $477\mathrm{.}00$

$48283,$ Alice martin, $781\mathrm{.}00$

$85437,$ Aaron james, $403\mathrm{.}75$