Question: Optional :CSV Problem - Extra Credit 20 points) name ID_number pay type pay_rate hours_worked The fields are separated by a tab t delimiter, and they

Optional :CSV Problem - Extra Credit 20 points)

name <\t> ID_number <\t> pay <\t> type <\t> pay_rate <\t> hours_worked

The fields are separated by a tab \t delimiter, and they are described as follows:

  1. name is a string value
  2. ID_number is a numeric integer value
  3. pay_type is a character, either H for hourly, or S for salary
  4. pay_rate either holds the hourly rate for an hourly pay_type, or it holds the total salary for a salary pay_type.
  5. hours_worked holds the total number of work hours for the employee

The employee gross pay is computed as follows:

If employee pay_type is hourly

gross pay = pay_rate * hours_worked

Else if employee pay_type is salary based

gross pay = pay_rate

Develop a solution for the problem of reading each employees information from the file, computing her gross pay, and then printing out all the employee information along with her gross pay.

Your solution development should include:

  1. PAC (20 points)
  2. Algorithms (20 points)

Rubric

PAC and algorithm of a fixed format text file are required for this question

the programming language is python. the question has been answered but not correctly so for this I need the PAC and Algorithm for python.thanks

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!