Database System Concepts
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
Bartleby Related Questions Icon
Related questions
bartleby
Concept explainers
Question
JAVA Program
Homework #1. Chapter 7. PC# 2. Payroll Class (page 488-489)
Write a Payroll class that uses the following arrays as fields:
* employeeId. An array of seven integers to hold employee identification numbers. The array should be initialized with the following numbers: 5658845 4520125 7895122 8777541 8451277 1302850 7580489
* hours. An array of seven integers to hold the number of hours worked by each employee
* payRate. An array of seven doubles to hold each employee’s hourly pay rate
* wages. An array of seven doubles to hold each employee’s gross wages
The class should relate the data in each array through the subscripts. For example, the number in element 0 of the hours array should be the number of hours worked by the
employee whose identification number is stored in element 0 of the employeeId array. That same employee’s pay rate should be stored in element 0 of the payRate array.
The class should have a method that accepts an employee’s identification number as an argument and returns the
gross pay for that employee. Demonstrate the class in a complete program that displays each employee number and asks the user to enter that employee’s hours and pay rate. It should then display each employee’s identification number and gross wages.
Input Validation: Do not accept negative values for hours or numbers less than 6.00 for pay rate.
PLEASE CREATE A WORKING CODE SO WHEN I UPLOAD IT TO HYPERGRADE IT PASSES ALL THE TEST CASSES. IT HAS TO PASS ALL THE TEST CASSES. ATTACHED IS THE FAILED PART. THANK YOU
Test Case 1
Please enter hours for employee ID: 5658845\n
41ENTER
Please enter pay rate for employee ID: 5658845\n
11ENTER
Please enter hours for employee ID: 4520125\n
42ENTER
Please enter pay rate for employee ID: 4520125\n
12ENTER
Please enter hours for employee ID: 7895122\n
43ENTER
Please enter pay rate for employee ID: 7895122\n
13ENTER
Please enter hours for employee ID: 8777541\n
44ENTER
Please enter pay rate for employee ID: 8777541\n
14ENTER
Please enter hours for employee ID: 8451277\n
45ENTER
Please enter pay rate for employee ID: 8451277\n
15ENTER
Please enter hours for employee ID: 1302850\n
46ENTER
Please enter pay rate for employee ID: 1302850\n
16ENTER
Please enter hours for employee ID: 7580489\n
47ENTER
Please enter pay rate for employee ID: 7580489\n
17ENTER
===========================\n
Employee ID\tGross Wages\n
===========================\n
5658845\t$ 451.00\n
4520125\t$ 504.00\n
7895122\t$ 559.00\n
8777541\t$ 616.00\n
8451277\t$ 675.00\n
1302850\t$ 736.00\n
7580489\t$ 799.00\n
41ENTER
Please enter pay rate for employee ID: 5658845\n
11ENTER
Please enter hours for employee ID: 4520125\n
42ENTER
Please enter pay rate for employee ID: 4520125\n
12ENTER
Please enter hours for employee ID: 7895122\n
43ENTER
Please enter pay rate for employee ID: 7895122\n
13ENTER
Please enter hours for employee ID: 8777541\n
44ENTER
Please enter pay rate for employee ID: 8777541\n
14ENTER
Please enter hours for employee ID: 8451277\n
45ENTER
Please enter pay rate for employee ID: 8451277\n
15ENTER
Please enter hours for employee ID: 1302850\n
46ENTER
Please enter pay rate for employee ID: 1302850\n
16ENTER
Please enter hours for employee ID: 7580489\n
47ENTER
Please enter pay rate for employee ID: 7580489\n
17ENTER
===========================\n
Employee ID\tGross Wages\n
===========================\n
5658845\t$ 451.00\n
4520125\t$ 504.00\n
7895122\t$ 559.00\n
8777541\t$ 616.00\n
8451277\t$ 675.00\n
1302850\t$ 736.00\n
7580489\t$ 799.00\n
Test Case 2
Please enter hours for employee ID: 5658845\n
-1ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 5658845\n
41ENTER
Please enter pay rate for employee ID: 5658845\n
1ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 5658845\n
11ENTER
Please enter hours for employee ID: 4520125\n
-2ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 4520125\n
42ENTER
Please enter pay rate for employee ID: 4520125\n
2ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 4520125\n
12ENTER
Please enter hours for employee ID: 7895122\n
-3ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 7895122\n
43ENTER
Please enter pay rate for employee ID: 7895122\n
3ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 7895122\n
13ENTER
Please enter hours for employee ID: 8777541\n
-4ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 8777541\n
44ENTER
Please enter pay rate for employee ID: 8777541\n
4ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 8777541\n
14ENTER
Please enter hours for employee ID: 8451277\n
-5ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 8451277\n
45ENTER
Please enter pay rate for employee ID: 8451277\n
5ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 8451277\n
15ENTER
Please enter hours for employee ID: 1302850\n
-6ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 1302850\n
46ENTER
Please enter pay rate for employee ID: 1302850\n
1.6ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 1302850\n
16ENTER
Please enter hours for employee ID: 7580489\n
-7ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 7580489\n
47ENTER
Please enter pay rate for employee ID: 7580489\n
1.7ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 7580489\n
17ENTER
===========================\n
Employee ID\tGross Wages\n
===========================\n
5658845\t$ 451.00\n
4520125\t$ 504.00\n
7895122\t$ 559.00\n
8777541\t$ 616.00\n
8451277\t$ 675.00\n
1302850\t$ 736.00\n
7580489\t$ 799.00\n
-1ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 5658845\n
41ENTER
Please enter pay rate for employee ID: 5658845\n
1ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 5658845\n
11ENTER
Please enter hours for employee ID: 4520125\n
-2ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 4520125\n
42ENTER
Please enter pay rate for employee ID: 4520125\n
2ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 4520125\n
12ENTER
Please enter hours for employee ID: 7895122\n
-3ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 7895122\n
43ENTER
Please enter pay rate for employee ID: 7895122\n
3ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 7895122\n
13ENTER
Please enter hours for employee ID: 8777541\n
-4ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 8777541\n
44ENTER
Please enter pay rate for employee ID: 8777541\n
4ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 8777541\n
14ENTER
Please enter hours for employee ID: 8451277\n
-5ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 8451277\n
45ENTER
Please enter pay rate for employee ID: 8451277\n
5ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 8451277\n
15ENTER
Please enter hours for employee ID: 1302850\n
-6ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 1302850\n
46ENTER
Please enter pay rate for employee ID: 1302850\n
1.6ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 1302850\n
16ENTER
Please enter hours for employee ID: 7580489\n
-7ENTER
Hours cannot be negative.\n
Please enter hours for employee ID: 7580489\n
47ENTER
Please enter pay rate for employee ID: 7580489\n
1.7ENTER
Employee pay rate cannot be less than 6ドル.00/hour.\n
Please enter pay rate for employee ID: 7580489\n
17ENTER
===========================\n
Employee ID\tGross Wages\n
===========================\n
5658845\t$ 451.00\n
4520125\t$ 504.00\n
7895122\t$ 559.00\n
8777541\t$ 616.00\n
8451277\t$ 675.00\n
1302850\t$ 736.00\n
7580489\t$ 799.00\n
Transcribed Image Text:\n
Employee ID \t Gross Wages\n
=\n
5658845 \t $
4520125 \t $
++
LA LA LA LA LA LA LA
7895122 \t $
8777541
8451277 \t
1302850 \t $
\t $
$
7580489 \t $
451.00 \n
504.00 \n
559.00 \n
616.00 \n
675.00 \n
736.00 \n
799.00 \n
Transcribed Image Text:Employee ID \t
5658845 \t
4520125 \t
7895122 \t
8777541 \t $
LA LA LA LA LA LA LA
$
$
==\n
Gross Wages\n
===\n
8451277 \t $
1302850 \t $
7580489 \t $
451.00 \n
504.00 \n
559.00 \n
616.00 \n
675.00 \n
736.00 \n
799.00\n
Expert Solution
Check Markarrow_forward
Step 1: Algorithm :
Algorithm: Payroll Class
1. Create a class called Payroll.
2. Declare private fields in the Payroll class:
- employeeId: an array of seven integers to hold employee identification numbers.
- hours: an array of seven integers to hold the number of hours worked by each employee.
- payRate: an array of seven doubles to hold each employee’s hourly pay rate.
- wages: an array of seven doubles to hold each employee’s gross wages.
3. Create setter methods in the Payroll class:
- setHours(index, hours):
- If hours >= 0:
- Set the hours at the specified index in the 'hours' array.
- Else:
- Print "Hours cannot be negative."
- setPayRate(index, payRate):
- If payRate >= 6.00:
- Set the payRate at the specified index in the 'payRate' array.
- Else:
- Print "Employee pay rate cannot be less than 6ドル.00/hour."
4. Create a method calculateWages(index) in the Payroll class:
- Calculate gross wages as hours[index] * payRate[index].
- Return the calculated gross wages.
5. In the main method:
- Create an instance of the Payroll class (e.g., payroll).
- Create a Scanner object (e.g., scanner) to read user input.
6. Use a for loop to iterate seven times (for each employee):
- Prompt the user to enter hours for the employee with the current employeeId.
- Read the entered hours and use payroll.setHours(index, hours) to set the hours for the current employee.
- Prompt the user to enter the pay rate for the employee with the current employeeId.
- Read the entered pay rate and use payroll.setPayRate(index, payRate) to set the pay rate for the current employee.
7. Print a header for the output:
- Print "===========================\nEmployee ID\tGross Wages\n===========================".
8. Use a for loop to calculate and display the gross wages for each employee:
- Calculate gross wages using payroll.calculateWages(index).
- Print the employee ID and gross wages in a formatted manner.
9. End the program.
bartleby
Step by stepSolved in 4 steps with 2 images
Knowledge Booster
Background pattern image
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.Similar questions
- 1- Write a class called items that has member variables name (string), price (double), quantity (integer). In main program, create an array of type items called arrayltem and store several item objects in this array. Note that main should create several item objects and save these objects in arrayltem. Write a static method called totalCost that accepts an array of items. This static method must calculate and return the total cost of items stored in the array. 2- Write a generic method called minimum that accepts four items and find the minimum of them. 3- Test your class with Integer, Double, Character, String and Car objects.arrow_forwardWrite a C# program that uses a class called ClassRegistration as outlined below: The ClassRegistration class is responsible for keeping track of the student id numbers for students that register for a particular class. Each class has a maximum number of students that it can accommodate. Responsibilities of the ClassRegistration class: It is responsible for storing the student id numbers for a particular class (in an array of integers) It is responsible for adding new student id numbers to this list (returns boolean) It is responsible for checking if a student id is in the list (returns a boolean) It is responsible for getting a list of all students in the class (returns a string). It is responsible for returning the number of students registered for the class (returns an integer) It is responsible for returning the maximum number of students the class is allowed (returns an integer) It is responsible for returning the name of the class. (returns a string)arrow_forwardJAVA PROGRAM Chapter 7. PC #1. Rainfall Class Write a RainFall class that stores the total rainfall for each of 12 months into an array of doubles. The program should have methods that return the following: • the total rainfall for the year • the average monthly rainfall • the month with the most rain • the month with the least rain Demonstrate the class in a complete program. Main class name: RainFall (no package name) est Case 1 Enter the rainfall amount for month 1:\n1.2ENTEREnter the rainfall amount for month 2:\n2.3ENTEREnter the rainfall amount for month 3:\n3.4ENTEREnter the rainfall amount for month 4:\n5.1ENTEREnter the rainfall amount for month 5:\n1.7ENTEREnter the rainfall amount for month 6:\n6.5ENTEREnter the rainfall amount for month 7:\n2.5ENTEREnter the rainfall amount for month 8:\n3.3ENTEREnter the rainfall amount for month 9:\n1.1ENTEREnter the rainfall amount for month 10:\n5.5ENTEREnter the rainfall amount for month 11:\n6.6ENTEREnter...arrow_forward
- JAVA PROGRAM Homework #2. Chapter 7. PC #13. Name Search (page 492) Read these instructions for additional requirements carefully. Write a program that reads the contents of the two files into two separate arrays. The user should be able to enter a name the application will display messages indicating whether the names were among the most popular. 1. GirlNames.txt and BoyNames.txt contain a list of the 200 most popular names given to girls/boys born in the United States for the years 2000 through 2009. 2. Your application should use an array to hold the names. 3. The program should continue interacting with the user indefinitely unless the user chooses to quit by entering "QUIT" (should be case insensitive). 4. The user should enter a single name and the program will search the name in both lists. The user SHOULD NOT specify whether the search is for girls name or boys name. The program is responsible for finding either or both and telling the user where it found it. 5....arrow_forward11:02 all 10% + Create 1 1000.01 Create 2 2000.02 Create 3 3000.03 Deposit 111.11 Deposit 2 22.22 Withdraw 4 5000.00 Create 4 4000.04 Withdraw 1 0.10 Balance 2 Withdraw 2 0.20 Deposit 3 33.33 Withdraw 4 0.40 Bad Command 65 Balance 1 Balance 2 Balance 3 Balance 4arrow_forwardJava code 8. Given an existing ArrayList named friendList, find the first index of a friend named Sasha and store it in a new variable named index. 9. Given that an ArrayList of Integers named numberList has already been created and several values have already been inserted, write the statement necessary to insert the value 25 at the end of the list. 10. Declare an integer array named evens and fill it with even numbers from 2 through 10 in one statement. 11. Given an existing array named pets, find the size of the array and store it in a new variable named numPets. 12. Given an existing ArrayList named contactList, find the number of contacts in the ArrayList and store it in the existing variable named numContacts.arrow_forward
- JAVA PROGRAM Homework #1. Chapter 7. PC# 2. Payroll Class (page 488-489) Write a Payroll class that uses the following arrays as fields: * employeeId. An array of seven integers to hold employee identification numbers. The array should be initialized with the following numbers: 5658845 4520125 7895122 8777541 8451277 1302850 7580489 * hours. An array of seven integers to hold the number of hours worked by each employee * payRate. An array of seven doubles to hold each employee’s hourly pay rate * wages. An array of seven doubles to hold each employee’s gross wages The class should relate the data in each array through the subscripts. For example, the number in element 0 of the hours array should be the number of hours worked by the employee whose identification number is stored in element 0 of the employeeId array. That same employee’s pay rate should be stored in element 0 of the payRate array. The class should have a method that accepts an employee’s identification...arrow_forward10 Build the Sudoku Reviewer ( the testing program). The specification is below. Please note: you DO NOT have to build a Sudoku solver. To test you just need to build a class that generates a 9x9 2D array with the values you want to test. You can assume the value types are valid. (integers from 1-9). 1-The main purpose is to make sure the Sudoku solver actually solved it correctly! 2- You are also confirming the solver solves puzzle in no longer than a minute 3- Solver (not the reviewer) requires 7 INDICES (ELEMENTS) filled in the input array at least. 4- The reviewer receives both the original puzzle and the solution. The Reviewer needs to confirm the solution is not only a valid SudoKu solution but also the solution to the original puzzle. 5- Solver will return a 2d array filled with -1s if input array has an error/bad input (exception). Reviewer will check for this case.arrow_forwardCreate an array of objects of the Person class, of size 4. Create three objects of the Person class, with values, and assign the objects to the array. Loop through the array and print the name, job, and email of all Personobjects.arrow_forward
- In C# Use a one-dimensional array to solve the following problem. Write a class called ScoreFinder. This class receives a single dimensional integer array representing passer ratings for NFL players as an argument for its constructor. The test class will provides this argument. The test class then calls upon a method from the ScoreFinder class to start the process of finding a specific rating, which will be provided by the user. The method will iterate through the array and find any matching values. For all the matches that are found, the method will note the index of the cell along with its value. At completion, the method will print a list of all the indices and the associated scores along with a count of all the matching values.arrow_forwardIn Java Assignment 5B : Maze Game! 2D Arrays can be used to store and represent informationabout video game levels or boards. In this exercise, you will use this knowledge tocreate an interactive game where players attempt to move through a maze. You willstart by creating a pre-defined 2D array with the following values:{"_","X","_","X","X"}{"_","X","_","X","W"}{"_","_","_","X","_"}{"X","X","_","_","_"}{"_","_","_","X","X"}You will then set the player (represented by "O") at index 0, 0 of the array, the top-leftcorner of the maze. You will use a loop to repeatedly prompt the user to enter adirection ("Left", "Right", "Up", or "Down"). Based on these directions, you will try tomove the player.• If the location is valid (represented by "_"), you will move the player there• If the location is out of bounds (e.g. index 0, -1) or the command is invalid, youwill inform the player and prompt them to enter another direction• If the location is a wall (represented by "X"), you will tell the...arrow_forwardRecipe Program - Java ONLYI am looking to create a program that is a recipe holder. It needs to include at a minimum: At least 1 loop An Array or ArrayList At least 3 Java classes Use of methods The program would allow the user to (as part of a menu selection): Add a recipe Include ingredient list Instructions List all recipes that are in the program (array) Display a single recipe Search Recipes (option to view recipe selected) For example, searching for peanut butter cookie would bring up the recipe or multiple if the same name. The user could then select one of them to view the recipe. Search Recipes with a single ingredient (option to view recipe selected) For example: search for coconut and it would bring up coconut cream pie and German chocolate cake. The user could then select one of them to view the recipe. Close application Also need the program in a UML diagram.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Text book imageDatabase System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationText book imageStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONText book imageDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- Text book imageC How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONText book imageDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningText book imageProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education