Develop a program to serve user requests to get stats on the employee base salary file (emp_base_salaries_homework3.csv) . This base salary file (emp_base_salaries_homework3.csv) is provided in your blackboard homework3 section This program will read user inputs as the program parameters at the execution of the program HE

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
Review View
Tell me
2
IN DUI TTUITIC WORKS
go
¶
I
AaBbccDite
Normal
Task 11
a. Develop a program to serve user requests to get stats on the employee base
(emp_base_salaries_homework3.csv)
salary file
b.
This base salary file (emp_base_salaries_homework3.csv) is provided in your
blackboard homework3 section
Ao Boccer
No Spacing
c. This program will read user inputs as the program parameters at the execution
of the program
d. You should be using python's argrarse module to read the python command line
AaBbCcDe
Heading 1
arguments
e. You must use try except block for any know error processing and show
f.
meaningful message in the output of the except block
Following will be the options for command line arguments
1. -total.emp.count or
1. This option should give the total employees in the file
2.-lookup key or
1. This option will lookup for the employee record based on the
lookup..key which the user wants to lookup for.
3. -sum totalPay
2. This option requires additional parameters to be passed. Those
additional parameters are
a. -lookup_valus
b. -return key value or
i. This is the value of the lookup key which the user
wants to search. For example if lookup_key, is id
then value can be any employee id ex: employee id
105
1. Here return key value is the value of which key
does user wants to see. For example if user passess
lookup key as ld and lookup_value as 105 and
return key value as BasePay then the expected
result is 134401.6
c-smp_totalPay (Sum of BasePay. OvertimePay. OtherPay.
and Benefits)
1. It is sum of totalPay (Sum of BasePay, OvertimePay. OtherPay.
and Benefits) of all employees
g. You must write separate functions for each of the calculation of each of the
options.
h. These functions should be written in separate python utility file and should be
imported in the main processing file
L You should name this utility file as Ingtid) homework3_util.py
Transcribed Image Text:Review View Tell me 2 IN DUI TTUITIC WORKS go ¶ I AaBbccDite Normal Task 11 a. Develop a program to serve user requests to get stats on the employee base (emp_base_salaries_homework3.csv) salary file b. This base salary file (emp_base_salaries_homework3.csv) is provided in your blackboard homework3 section Ao Boccer No Spacing c. This program will read user inputs as the program parameters at the execution of the program d. You should be using python's argrarse module to read the python command line AaBbCcDe Heading 1 arguments e. You must use try except block for any know error processing and show f. meaningful message in the output of the except block Following will be the options for command line arguments 1. -total.emp.count or 1. This option should give the total employees in the file 2.-lookup key or 1. This option will lookup for the employee record based on the lookup..key which the user wants to lookup for. 3. -sum totalPay 2. This option requires additional parameters to be passed. Those additional parameters are a. -lookup_valus b. -return key value or i. This is the value of the lookup key which the user wants to search. For example if lookup_key, is id then value can be any employee id ex: employee id 105 1. Here return key value is the value of which key does user wants to see. For example if user passess lookup key as ld and lookup_value as 105 and return key value as BasePay then the expected result is 134401.6 c-smp_totalPay (Sum of BasePay. OvertimePay. OtherPay. and Benefits) 1. It is sum of totalPay (Sum of BasePay, OvertimePay. OtherPay. and Benefits) of all employees g. You must write separate functions for each of the calculation of each of the options. h. These functions should be written in separate python utility file and should be imported in the main processing file L You should name this utility file as Ingtid) homework3_util.py
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
File Input and Output Operations
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
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