Write a Python script to create and manage a very basic personnel database for a human...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
• Write a Python script to create and manage a very basic personnel database for a human resources department in a fictional organisation. • The personnel database should be stored in a simple Python list, where each item in the list is one employee record. Additionally, each individual employee record should be stored in a Python tuple. . o An employee record should consist of: A unique ID number Employee surname Employee first name(s) Job title Full time (simply considered as yes or no) Hourly rate (in £) Hours per week • Write some code that allows the user to enter the details for a new employee record; remember to consider the data type for each item in the employee record. This code should also add the new employee record (Python tuple) to the personnel database (Python list). . . ■ Write some code that will display, in a suitable format, the database inventory - an output of all the names of employees (first name(s) and surnames) currently stored in the database. Now write some code to add a repeating menu system to your program and therefore allow the user to select options to add further employee records and re-display the database inventory. The menu at this stage should look similar to the following: Human Resources department Personnel Database +-+-+-+-+-+-+-+-+ a. b. C. Add a new employee record Display all employees Exit Choose an option (a to c) Add an option to your program to allow the user to search the database for an individual employee (by first name or surname) and display, in a suitable format, the full details of any matching records. • Add an option to your program to allow the user to delete an entry from the database (.e. remove an employee record). • Add two more options to the main menu to allow the user to view a filtered list of all full-time employees and a filtered list of all part-time employees. Finally add some code to display on the main menu how many employee records are currently stored in the database. When you are finished you should have a program with a repeating menu system which looks similar to the following: Human Resources department Personnel Database (Employee records: n) a. Add a new employee record b. C. d. e. Display all employees Search for employee record (view details) Delete an employee record Show full-time employees Show all part-time employees X. Exit Choose an option (a to f) or x to Exit All options should return to this menu when completed (apart from the last one). Advanced Tasks: • Add two further options to the main menu of the program to allow the user to: o View a list of all employee records sorted alphabetically (A-Z) by either surname or job title - the user should be given the choice. o View a list of all employees with a total weekly cost to the organisation greater than an entered value. The total weekly cost of each employee should be calculated as: hours per week hourly rate using the data held in the database at the time. 2 • Write a Python script to create and manage a very basic personnel database for a human resources department in a fictional organisation. • The personnel database should be stored in a simple Python list, where each item in the list is one employee record. Additionally, each individual employee record should be stored in a Python tuple. . o An employee record should consist of: A unique ID number Employee surname Employee first name(s) Job title Full time (simply considered as yes or no) Hourly rate (in £) Hours per week • Write some code that allows the user to enter the details for a new employee record; remember to consider the data type for each item in the employee record. This code should also add the new employee record (Python tuple) to the personnel database (Python list). . . ■ Write some code that will display, in a suitable format, the database inventory - an output of all the names of employees (first name(s) and surnames) currently stored in the database. Now write some code to add a repeating menu system to your program and therefore allow the user to select options to add further employee records and re-display the database inventory. The menu at this stage should look similar to the following: Human Resources department Personnel Database +-+-+-+-+-+-+-+-+ a. b. C. Add a new employee record Display all employees Exit Choose an option (a to c) Add an option to your program to allow the user to search the database for an individual employee (by first name or surname) and display, in a suitable format, the full details of any matching records. • Add an option to your program to allow the user to delete an entry from the database (.e. remove an employee record). • Add two more options to the main menu to allow the user to view a filtered list of all full-time employees and a filtered list of all part-time employees. Finally add some code to display on the main menu how many employee records are currently stored in the database. When you are finished you should have a program with a repeating menu system which looks similar to the following: Human Resources department Personnel Database (Employee records: n) a. Add a new employee record b. C. d. e. Display all employees Search for employee record (view details) Delete an employee record Show full-time employees Show all part-time employees X. Exit Choose an option (a to f) or x to Exit All options should return to this menu when completed (apart from the last one). Advanced Tasks: • Add two further options to the main menu of the program to allow the user to: o View a list of all employee records sorted alphabetically (A-Z) by either surname or job title - the user should be given the choice. o View a list of all employees with a total weekly cost to the organisation greater than an entered value. The total weekly cost of each employee should be calculated as: hours per week hourly rate using the data held in the database at the time. 2
Expert Answer:
Answer rating: 100% (QA)
python class EmployeeDatabase def initself selfpersonneldatabase def addemployeeself uniqueid inputEnter unique ID number surname inputEnter employee ... View the full answer
Related Book For
Project Management The Managerial Process
ISBN: 9781260570434
8th Edition
Authors: Eric W Larson, Clifford F. Gray
Posted Date:
Students also viewed these programming questions
-
Use quadratic formula to find the x-intercept s y=x^(2)-2x+5
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Two independent situations follow: 1. Ready Car Rental leased a car to Culver Company for three months. Terms of the lease agreement call for monthly payments of $885, beginning on May 21, 2024....
-
City Motors is a chain of car dealerships. Sales in the fourth quarter of last year were $4,000,000. Suppose its management projects that its current year's quarterly sales will increase by 3% in...
-
Your FICO score is a commonly used measure of credit risk (see www.myfico.com). A score of 850 is the best (highest) score possible. Thirty-five percent of the FICO score is based on payment history...
-
In a test of homogeneity, the alternate hypothesis says that the distributions in the rows are the same. In Exercises 68, determine whether the statement is true or false. If the statement is false,...
-
Starbright Coffee Shop at the Galleria Mall serves two coffee blends it brews on a daily basis, Pomona and Coastal. Each is a blend of three high-quality coffees from Colombia, Kenya, and Indonesia....
-
#pragma once // A Binary Search Tree implementation. template class BSTree { private: // A node in the tree. Each node has pointers to its left and right nodes // as well as its parent. When a node...
-
A beam of T section is supported and loaded as shown. a) (15 pts) Construct the shear and bending moment diagram, provide expressions for the shear and bending moment on each segment, provide graphs,...
-
Blossom Sports began operations on January 2, 2020. The following stock record card for footballs was taken from the records at the end of the year. Unit Invoice Gross Invoice Units Received Date...
-
17 years ago, Amelia andd Beatrice each invested $17,350. Amelia's account pays 6.2 percent simple interest, while Beatrice's account pays 6.2 percent compounded annually. How much more interest has...
-
You plan to deposit $2,900 per year for 8 years in an account earning 4.4 percent interest, compounded annually. If the first deposit is made next year, how much will you have in year 19?
-
(a) During lunch hour, arrivals of customers at a pizza hut restaurant follows a Poisson process with the rate of 120 customers per hour. The restaurant has one line, with three workers taking food...
-
You want to purchase a $140,000 sports car, You have $36,000 today that can be Invested in an account that pays 6.G percent annual interest. Assuming the price of the car remains constant, how many...
-
Robin Hood was an excellent archer and was the owner of Straight Shot Archery, Incorporated. The Merryman Annual Archery Tournament was taking place in three months. Friar Tuck wanted to compete in...
-
According to the bank 's terms, monthly payments under the loan amount to 1500 d.e. The loan was issued for a period of 10 years at 14% per annum. The investor 's own funds for this project amount to...
-
A number of years ago the United Food and Commercial Workers Union organized 800 workers of the 1035 employees at one of the Wilson Brothers food operations in Toronto, Ontario. The employees include...
-
Shell Case Fabricators (SCF) designs and builds shell casings that enclose electronic products such as calculators, cell phones, and modems. Typically the cases are plastic or plastic compounds. SCF...
-
Why do organizations use the percent complete instead of the cheaper, easier pseudo-earned value percent approach?
-
Why would people resist a multiproject resource scheduling system?
-
A _______________ interval estimates the mean y-value for all individuals with a given x-value. In Exercises 3 and 4, fill in each blank with the appropriate word or phrase.
-
For a sample of size n = 20, the following values were obtained: b0 = 1.05, b1 = 4.50, se = 0.54, (x x )2 = 10.9, x = 8.52. Construct a 95% confidence interval for the mean response when x = 10.
-
In Exercises 9 and 10, use the given set of points to a. Compute b0 and b1. b. Compute the predicted value y for the given value of x. c. Compute the residual standard deviation se. d. Compute the...
Study smarter with the SolutionInn App