Write a python program that accepts name of an employee and employee's yearly sales of last five years. The data should be collected for n employees.

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
Using list,f’string, write python language
SalaryStmt.py
Write a python program that accepts name of an employee and
employee's yearly sales of last five years. The data should be
collected for n employees.
The value ofn should also be accepted as input.
All amounts should be displayed with three decimal places.
The output should be displayed as a table containing the Employee
name, Average Sales and Bonus.
The program must define and use a function with Total Sales as a
parameter and should calculate the Average Sales and Bonus for
each employee. Bonus must be calculated based on the following
table:
Bonus
1% of Average Sales
2% of Average Sales
4% of Average Sales
7% of Average Sales
Average Sales (AS)
AS<5000
50002AS<7500
75002AS<10000
AS210000
Sample Output
===== =====
=====
Employee Name
Average Sales
Bonus
==== ==== ==== ======
======
AFRAH
ASMA
8577.000
343.080
6476.800
129.536
49.430
718.200
ATHEER
4943.000
HAJAR
10260.000
315.064
135.608
MALLAK
7876.600
MARYAM
6780.400
NOORA
8822.200
352.888
SAHAR
9126.800
365.072
SHEFAA
7631.000
305.240
TAGHARID
7580.400
303.216
==== =====
======
Transcribed Image Text:SalaryStmt.py Write a python program that accepts name of an employee and employee's yearly sales of last five years. The data should be collected for n employees. The value ofn should also be accepted as input. All amounts should be displayed with three decimal places. The output should be displayed as a table containing the Employee name, Average Sales and Bonus. The program must define and use a function with Total Sales as a parameter and should calculate the Average Sales and Bonus for each employee. Bonus must be calculated based on the following table: Bonus 1% of Average Sales 2% of Average Sales 4% of Average Sales 7% of Average Sales Average Sales (AS) AS<5000 50002AS<7500 75002AS<10000 AS210000 Sample Output ===== ===== ===== Employee Name Average Sales Bonus ==== ==== ==== ====== ====== AFRAH ASMA 8577.000 343.080 6476.800 129.536 49.430 718.200 ATHEER 4943.000 HAJAR 10260.000 315.064 135.608 MALLAK 7876.600 MARYAM 6780.400 NOORA 8822.200 352.888 SAHAR 9126.800 365.072 SHEFAA 7631.000 305.240 TAGHARID 7580.400 303.216 ==== ===== ======
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Introduction to computer system
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.
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