
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Write a program that inputs a filename from the user and prints to the terminal a report of the wages paid to the employees for the given period. The report should be in tabular format with the appropriate header. Each line should contain an employee’s name, the hours worked, and the wages paid for that period. The wages paid are equal to the hourly wage * hours worked + tips.
Use the sample data using python:
Berg 7.25 32 110.75
Turner 8.00 40 0
Roman 10.0 50 0
Pugh 7.25 32 22.75
Potter 8.75 20 0
Savage 9.50 40 55.0
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images

Knowledge Booster
Similar questions
- Use matlab to determine the answer. Use the function file then call the function to get the answer in a script file.arrow_forwardPYTHON: I need to get the avg statement out of the loop so that the output prints correctly. Any suggestions. Write a program that reads the student information from a tab separated values (tsv) file. The program then creates a text file that records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student. A sample of the student information is provided in StudentInfo.tsv. Assume the number of students is at least 1 and at most 20. The program performs the following tasks: Read the file name of the tsv file from the user. Open the tsv file and read the student information. Compute the average exam score of each student. Assign a letter grade to each student based on the average exam score in the following scale: A: 90 =< x B: 80 =< x < 90 C: 70 =< x < 80 D: 60 =< x < 70 F: x < 60 Compute the average of each exam. Output the last names, first names, exam…arrow_forwardpython Write a function that reads in a text file, and counts the number of times each word occursin the file. Then print the words alphabetically with its corresponding count. Each word willbe separated by a space or newline, but there is no guarantee that each word will be on aseparate line.arrow_forward
- Write a script file that will ask the user for an integer. Your program must use the “mod” function to find all the composite numbers up to and including the number input by the user. You cannot use the “isprime” function in MATLAB. You must use a nested loop and the “mod” function to determine the composite numbers.This program will find all the composite numbers up to and including the integer you input. Please input an integer: 11 4 is a composite number! 6 is a composite number! 8 is a composite number! 9 is a composite number! 10 is a composite number!arrow_forwardI need this code to pythonarrow_forwardI know you are using Al tools to generate answer but I don't want these answers. If I see Al or plagiarism in my response I'll definitely reduce rating and will report for sure. So be careful. I'll take serious action. Scenario involving a list of books stored in a file named "Books.txt." Create a Python program that performs the following tasks: Output all books in your list. Output books published between the years 2015 and 2020. Calculate the average rating of all books. Create a histogram of the number of books in each genre. Each element in the histogram should represent the count of books in a specific genre. Take all the books in "Books.txt" and store them in a Python set. Output all unique authors of the books. Output the total number of entries in your set. Books.txt: "The Silent Observer," 2018, Mystery, Emily Williams "Beyond the Horizon," 2016, Fantasy, David Thompson "Code Breakers," 2019, Thriller, Sarah Miller "Infinite Realms," 2017, Sci-Fi, Mark Anderson "Whispers of…arrow_forward
- assume the input data is structured as follows: first there is a non negative inetger specifying the number of empolyee timesheets to be read in. This is followed by data for each of the employees. The first number for each employee is an integer that specifies their pay per hour in cents. Following this are 5 integers, the numbers of hours they worked on each of the days of the workweek. Given this data, write a loop and any necessary code that reads the data and stores the total payroll of all employees into the variable total. note that you will have to add up the numbers worked by each employee and multiply that by that particular emplyee's pay rate to get the employee's pay for the week and sum those valuses into total. using python and nested loopsarrow_forwardDesign a modular program in Python to process payroll for all hourly paid employees, save all the data into a text file and make a backup file as well. The program should allow user enter each employee's ID, name, hours worked, and hourly pay rate. And then calculate gross pay with overtime hours(hours beyond 40) paid 50% more. And then the program should display pay statement for each employee and store them into a same text file. The program should display total number of employees, total number of hours worked by all employees, and total gross pay and save them at the end of the same text file as well. The program should contain the following functions: main(), get_employee_info(), calc_gross_pay(hours, rate), display_pay_statement(emp_id, emp_name, hours_horked, hourly_pay_rate, gross_pay), save_pay_statement_to_file(file_object, emp_id, emp_name, hours_worked, hourly_pay_rate, gross_pay), save_summary_to_file(file_object, number_of_employees, total_hours_worked, total_gross_pay).…arrow_forward9b_act2. Please help me answer this in python programming.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

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)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education