A company stores payment information for their employee working on a project and paid on a project basis, in a text file whose name is entered through keyboard (see a sample input file below). The first line of the file indicates the number of employees and each subsequent line corresponds to information related to an employee payment (employee name, number of hours worked and his/her hourly wage). Write a python program that reads such a file and displays the employees' names, their hours worked, and their salaries. Finally, it displays the total payment. Your program should consider the following erroneous cases: • The file does not open/exist The format of the data in the file is incorrect (e.g. hours = "1-" or salary = "unkown") in which case a RuntimeError exception should be raised and the processing should continue

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Design a python program with comments
Exercise 3:
A company stores payment information for their employee working on a project and paid on a
project basis, in a text file whose name is entered through keyboard (see a sample input file
below). The first line of the file indicates the number of employees and each subsequent line
corresponds to information related to an employee payment (employee name, number of hours
worked and his/her hourly wage). Write a python program that reads such a file and displays
the employees' names, their hours worked, and their salaries. Finally, it displays the total
payment. Your program should consider the following erroneous cases:
• The file does not open/exist
The format of the data in the file is incorrect (e.g. hours = "1-" or salary = "unkown")
in which case a RuntimeError exception should be raised and the processing should
continue
Enter input filename: employees.txt
Employee
Hours
Salary
Badria Al-Harthi: 11
520
Badria Al-Harthi
11
5720.0
Youcef Al-Busaidi: 19 720
Youcef Al-Busaidi
19
13680.0
Salim Al-Hajri:
Majid Al-Sinani:
1-
890
File contents invalid.
9.
1060
Majid Al-Sinani
File contents invalid.
9
9540.0
Amer Al-Shidani: 10 unkown
Total payement
28940.0
Sample input file
Sample output
Transcribed Image Text:Exercise 3: A company stores payment information for their employee working on a project and paid on a project basis, in a text file whose name is entered through keyboard (see a sample input file below). The first line of the file indicates the number of employees and each subsequent line corresponds to information related to an employee payment (employee name, number of hours worked and his/her hourly wage). Write a python program that reads such a file and displays the employees' names, their hours worked, and their salaries. Finally, it displays the total payment. Your program should consider the following erroneous cases: • The file does not open/exist The format of the data in the file is incorrect (e.g. hours = "1-" or salary = "unkown") in which case a RuntimeError exception should be raised and the processing should continue Enter input filename: employees.txt Employee Hours Salary Badria Al-Harthi: 11 520 Badria Al-Harthi 11 5720.0 Youcef Al-Busaidi: 19 720 Youcef Al-Busaidi 19 13680.0 Salim Al-Hajri: Majid Al-Sinani: 1- 890 File contents invalid. 9. 1060 Majid Al-Sinani File contents invalid. 9 9540.0 Amer Al-Shidani: 10 unkown Total payement 28940.0 Sample input file Sample output
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Top down approach design
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education