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: Average Sales (AS) AS<5000 5000>AS<7500 75002AS<10000 Bonus 1% of Average Sales 2% of Average Sales 4% of Average Sales 7% of Average Sales AS210000

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: Average Sales (AS) AS<5000 5000>AS<7500 75002AS<10000 Bonus 1% of Average Sales 2% of Average Sales 4% of Average Sales 7% of Average Sales AS210000

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

See similar textbooks

Similar questions

Create c# program
In python, write a function that receives three parameters: name, weight, and height. The default value for name is James. The function calculates the BMI and returns it. BMI is: weight/(height^2). Weight should be in kg and height should be in meters. For instance, if the weight is 60 kg and the height is 1.7 m, then the BMI should be 20.76. The function should print the name and BMI. The function should return 'BMI is greater than 22' if the MBI is greater than or equal to 22. Otherwise, the function should return 'BMI is less than 22'. Call the function and print its output.
Please complete the exercise as instructed and do not add global variables. Thank you
Write a program that calculates the balance of a checking account at the end of a three- month period. It should ask the user for the starting balance. Then a loop (for loop is recommended) should iterate once for every month in the period, performing the followi 1. Ask the user for the total amount deposited into the account during that month. Do n accept negative number. This deposit should be added to the current balance to make current balance is up to date. 2. Ask the user for the total amount withdrawn from the account during that month. Do accept negative amount or amount greater than the current balance. The withdrawal amount should be subtracted from current balance, so current balance is up to date. 3. Update the total deposit. 4. Update the total withdrawal After the last iteration, the program should display the following information: 1. starting balance at the beginning of the three-month 2. total deposits/withdrawals made during the three-month period 3. final balance…
in c++
Write a program that takes input two numbers for and store it in two variables named gross_salary and savings. The program then passes these two values to a function named calculate_tax(). The calculate_tax() function determines the tax amount as per the following criteria: i. If savings are less than 100,000, the whole amount will not be included in taxable income. However, if the amount is more than 100,000 (suppose 110,000), the amount that will be included in the taxable income will be calculated as follows: Savings - 100,000 as we supposed our savings are 110,000, the above formula will give value as under: 110,000 - 100,000 = 10,000 This means, if we have savings of 110,000, only 10,000 will be included in taxable income. So, the total taxable income will be calculated as under if (savings >100.000) taxable income = gross_salary + (savings - 100,000) else taxable_income = gross_salary + savings Note : this c++ program please try to solve within 30 minutes
# Question 4def costume_rating(costume_color, bling_value): """ Returns a function that calculates the number of candies to return based on the costume color, bling value, and phrase length. Args: costume_color (str): The color of your costume. Must be one of 'blue', 'red', 'green', 'yellow', 'purple', or 'orange'. bling_value (int): Represents how shiny your costume is. Must be a positive integer. Returns: A function that takes in one parameter: phrase (str): The phrase said by the trick-or-treater. >>> costume_rater = costume_rating('blue', 5) >>> costume_rater('19 Character Phrase') 85 >>> costume_rater('e') 0 >>> costume_rater('seven c') 1 >>> costume_rater = costume_rating('orange', 8) >>> costume_rater('hello i want candy') 14 >>> costume_rater = costume_rating('yellow', 5) >>> costume_rater('please give me…
Task 2: Using Function-Temperature Table The formula for converting a temperature from Fahrenheit to Celsius is: 5 C = (F-32) Where F is the Fahrenheit temperature and C is the Celsius temperature. Write a function named Celsius that accepts a Fahrenheit temperature as an argument. The function should return the temperature, converted to Celsius. Demonstrate the function by calling it in a loop that displays a table of Fahrenheit temp. 0 through 20 and there Celsius equivalents. The program should display the number of numbers found in the file, the sum of the numbers, and the average of the numbers.
answer this question in Python
A function named validGPA() to validate the GPA. A valid GPA value must be between 0 and 4 inclusive. The function must return the value of GPA and must take value of GPA as parameter.
PROGRAMMING LANGUAGE: C++ Modify the program using the discussed sample program that will give the following output and use a function with parameter and no return type.
Problem 2: Simple Interest The formula for computing the future value of an amount that is increasing due to accumulating simple interest is F=P(1+rxi) Where F is the future value, P is the present value, is the annual interest rate (decimal value not percent), and is the total time period in years. Write a function named simpleInterest that accepts values for the three variables P, and and assings them to the output variable futureValue Function Code to call your function > Save C Reset function [futureValue] =simpleInterest (presentValue, interest RatePercent, time Years) %Enter commands to perform the computation and assign the results 3 %to the output variable defined in the function command in line 1. 1 [futureValue] =simpleInterest (10000,5.25,5) My Solutions > MATLAB Documentation C Reset Run Function