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....
-
Height versus Arm Span Construct and interpret a 95% confidence interval for the population mean difference between height and arm span using the data from Problem 8. What does the interval lead us...
-
During March 2017, Toby Tool & Die Company worked on four jobs. A review of direct labor costs reveals the following summary data. Analysis reveals that Job A257 was a repeat job. Job A258 was a rush...
-
Explain how an auditor tests the existence of investments recorded within a client's financial statements.
-
Natalie and Curtis have comparative balance sheets and income statements for Cookie & Coffee Creations Inc. They have been told that they can use these financial statements to prepare horizontal and...
-
rt a letter to Rose McBride. Writing Plan - Refusal to a Request Rubric Buffer: Start with a neutral statement on which both reader and writer can agree, such as a compliment, appreciation, a quick...
-
1. If topaz is harder than quartz, then it will scratch quartz and also feldspar. Topaz is harder than quartz and it is also harder than calcite. Therefore, either topaz will scratch quartz or it...
-
Choose a union with no less than 100,000 members. To assist you, here is an expansive list of options from which to choose. https://en.wikipedia.org/wiki/List_of_labor_unions_in_the_United_States...
-
The process for the prices of a 5-year maturity zero-coupon bond and of a derivative on the interest rate that matures in three years are decribed by the following trees. The probablities that an...
-
A cylindrical conductor of uniform cross-section has resistivity p. The end-to- end separation is L and the cross-section end-face surface area is A. One end is at 10V and the other is at OV. a)...
-
A project is estimated to complete in 6 months. Refer to the table below. The total budgeted cost is $ till completion of the whole project. The cumulative budgeted cost is $ at the end of month 4....
-
Once you have analyzed your business data, there are two questions the article by Walter (2014) recommends considering when evaluating correlations in the data: "How confident are you in the...
-
you will be completing the DMAIC methodology to improve the process for CRAYONS Task 1: Complete each step of the DMAIC process methodology. Refer to the DMAIC Methodology table on slide 19 of the...
-
Carlisle & Co. is a British firm and wants to expand its business to the African continent. They are in the process of understanding the political risks and financial risks of the different African...
-
During the month, services performed for customers on account amounted to $7,500 and collections from customers in payment of their accounts totaled $6,000. At the end of the month, the Accounts...
-
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?
-
The upper curve in the boiling point diagram is called (a) The saturated vapour curve (b) The dew point curve (c) The saturated liquid curve (d) Both (a) and (b).
-
A vertical cylinder containing helium gas is filled with a piston of \(50 \mathrm{~kg}\) mass and crosssectional area of \(0.025 \mathrm{~m}^{2}\). If the atmospheric pressure outside the cylinder is...
-
The Joule-Thomson coefficient for any gas at inversion point is (a) 1 (b) 0 (c) 2 (d) 3
Study smarter with the SolutionInn App