Suppose XYZ Corp. is an IT service providing company. Employee details of the company are stored...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose XYZ Corp. is an IT service providing company. Employee details of the company are stored in the following table: Table name: Employees_ where empID is your employee id (for example Employees _12345) - emp_id (Primary key) - emp_name - salary (default salary should be 20000.00) - department (should only accept values "HR", "Finance" and "IT") Create the above table in oracle DB and insert following records in the same order: I (101, "Alex", 50000.50, "HR") (102, "Rob", 80000.55, "HR") (210, "Ronald", 50000.99, "Finance") (104, "Robin", 90000.50, "IT") (105, "Elissa", 20000.00, "Finance") make use of default salary insertion for this record (220, "Julie", 50000.50, "Finance") 2 / 2 | Instructions: 100% +1 Create the table in database and set up the data as instructed to do the operations. Table names should be in the format Employees_ Create the Java project maintaining coding standard and structure. Call the implemented methods from a demo/main class to get results and print/show your output. For all the method calls you should handle the success and failure cases properly while printing results. You need to submit/upload the following (Put both the deliverables in a folder and upload as a single zip file under the iON activity: Zip file name: Solution_ for e.g. Solution_12345.zip/7z A document containing all your table creation and insertion queries along with result screenshots I Your Java Project ** IMPORTANT: Deadline for submission: 5 PM EST - 19th September 2022 You can upload your deliverable (zip file) ONLY once. Pls. Note: The end time/due time for solution upload is fixed (5 PM EST). After that, the activity will be disabled, and no further submission will be allowed. So, ensure to start the test on time and move to coding section as soon as it is enabled so that you can ! Rain... SQL> A C 1 / 2 4. | - 100% + | Select all employees belonging to a particular department (passed as input) and getting salary greater than the input salary 3. public void deleteEmployee(int empld) throws EmployeeNotFoundExcpetion This method deletes the employee with the given empid from the table. If there is no employee with the given emp id, then throw a user defined exception "EmployeeNotFoundException" Instructions: public boolean update Employee Department(int empld, String newDepartment) Updates the department of the employee having the given empid with the newDepartment. Note: If CHECK constraint violated for department name, report an error accordingly. I Create the table in database and set up the data as instructed to do the operations. Table names should be in the format Employees_ Create the Java project maintaining coding standard and structure. Call the implemented methods from a domo/main class to get results and print/chow your Rain... 3:17 9/19 - department (should only accept values "HR", "Finance" and "IT") Create the above table in oracle DB and insert following records in the same order: (101, "Alex", 50000.50, "HR") (102, "Rob", 80000.55, "HR") (210, "Ronald", 50000.99, "Finance") (104, "Robin", 90000.50, "IT") (105, "Elissa", 20000.00, "Finance") make use of default salary insertion for this record (220, "Julie", 50000.50, "Finance") The company wants to automate the process of managing employee records and wants to implement following functionalities which will be managed through a dava application. 1. public boolean addEmployee (Employee e) Too add a new employee in the records. 2. public ArrayList get Employees With DepartmentAndSalary(String depName, double inputSalary) Select all employees belonging to a particular department (passed as input) and getting salary greater than the input salary 3. public void delete Employee(int empld) throws EmployeeNotFoundExcpetion with the given empid from the table. If there is no employee 7:17 PM Suppose XYZ Corp. is an IT service providing company. Employee details of the company are stored in the following table: Table name: Employees_ where empID is your employee id (for example Employees _12345) - emp_id (Primary key) - emp_name - salary (default salary should be 20000.00) - department (should only accept values "HR", "Finance" and "IT") Create the above table in oracle DB and insert following records in the same order: I (101, "Alex", 50000.50, "HR") (102, "Rob", 80000.55, "HR") (210, "Ronald", 50000.99, "Finance") (104, "Robin", 90000.50, "IT") (105, "Elissa", 20000.00, "Finance") make use of default salary insertion for this record (220, "Julie", 50000.50, "Finance") 2 / 2 | Instructions: 100% +1 Create the table in database and set up the data as instructed to do the operations. Table names should be in the format Employees_ Create the Java project maintaining coding standard and structure. Call the implemented methods from a demo/main class to get results and print/show your output. For all the method calls you should handle the success and failure cases properly while printing results. You need to submit/upload the following (Put both the deliverables in a folder and upload as a single zip file under the iON activity: Zip file name: Solution_ for e.g. Solution_12345.zip/7z A document containing all your table creation and insertion queries along with result screenshots I Your Java Project ** IMPORTANT: Deadline for submission: 5 PM EST - 19th September 2022 You can upload your deliverable (zip file) ONLY once. Pls. Note: The end time/due time for solution upload is fixed (5 PM EST). After that, the activity will be disabled, and no further submission will be allowed. So, ensure to start the test on time and move to coding section as soon as it is enabled so that you can ! Rain... SQL> A C 1 / 2 4. | - 100% + | Select all employees belonging to a particular department (passed as input) and getting salary greater than the input salary 3. public void deleteEmployee(int empld) throws EmployeeNotFoundExcpetion This method deletes the employee with the given empid from the table. If there is no employee with the given emp id, then throw a user defined exception "EmployeeNotFoundException" Instructions: public boolean update Employee Department(int empld, String newDepartment) Updates the department of the employee having the given empid with the newDepartment. Note: If CHECK constraint violated for department name, report an error accordingly. I Create the table in database and set up the data as instructed to do the operations. Table names should be in the format Employees_ Create the Java project maintaining coding standard and structure. Call the implemented methods from a domo/main class to get results and print/chow your Rain... 3:17 9/19 - department (should only accept values "HR", "Finance" and "IT") Create the above table in oracle DB and insert following records in the same order: (101, "Alex", 50000.50, "HR") (102, "Rob", 80000.55, "HR") (210, "Ronald", 50000.99, "Finance") (104, "Robin", 90000.50, "IT") (105, "Elissa", 20000.00, "Finance") make use of default salary insertion for this record (220, "Julie", 50000.50, "Finance") The company wants to automate the process of managing employee records and wants to implement following functionalities which will be managed through a dava application. 1. public boolean addEmployee (Employee e) Too add a new employee in the records. 2. public ArrayList get Employees With DepartmentAndSalary(String depName, double inputSalary) Select all employees belonging to a particular department (passed as input) and getting salary greater than the input salary 3. public void delete Employee(int empld) throws EmployeeNotFoundExcpetion with the given empid from the table. If there is no employee 7:17 PM
Expert Answer:
Related Book For
Principles of Auditing and Other Assurance Services
ISBN: 978-0078025617
19th edition
Authors: Ray Whittington, Kurt Pany
Posted Date:
Students also viewed these programming questions
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
Which of the following statements best describes the 'dilation' in rock mechanics? a. Movement of the rock along the shear direction during the direct shear tests b. Radial expansion of the intact...
-
On June 30, 2016, the market interest rate is 6%. Grommet Candies Ltd. issues $2,000,000 of 8%, 10-year bonds payable. The bonds pay interest on June 30 and December 31. Grommet Candies Ltd....
-
1) Calculate the Operating Cycle. 2) Calculate the Cash Cycle 3) List an idea to improve the Operating Cycle 4) List an idea to improve the Cash Cycle
-
How a third party can intervene in an action?
-
Suppose there are two countries. In the rich country, the representative consumer has Hr units of human capital, and total factor productivity is zr. In the poor country, the representative consumer...
-
ln x Consider the function f(x): = x (a) There is a single extrema on the graph of f(x) which is a maxima. Find the coordinates of the maximum point. You do not need to justify your answer. (b)...
-
Farm Fresh Ltd is a manufacturer of farm equipment that is sold by a network of distributors across Australia and New Zealand. The Service Division manufactures spare parts for the various models of...
-
Given the following group multiplication table for the C4 point group =Cu E CUE" -1 C4- E- C4- C2 C434 EO E E- C4 C2 C4 Cy-4 -E-- t C2 C4 Ci CAC2 C43.-E1 Cu Cu C C4 (8) C2- -C2C3-E- C44 CA C E--C-...
-
Jack is considering setting up a business to deliver outdoor fitness training weekends for company executives working in London's investment banks. Each weekend course will be run for an individual...
-
Helium is pumped into a spherical balloon at a rate of 3 cubic feet per second. How fast is the radius increasing after 3 minutes? Note: The volume of a sphere is given by V = (4/3). Rate of change...
-
2012 Brian S. Batterton, Attorney, PATC Legal & Liability Risk Management Institute (www.llrmi.com) It is well known that police must provide suspects with Miranda warnings for custodial questioning....
-
Analyze each of the following transactions by showing the effects on the accounting equation-specifically. identify the counts and amounts (including + or -) for each transaction. Note: Enter amounts...
-
The Armond Company records these journal entries: Issue Common Stock for Cash $200 Accrued Expense $55 Receive income in advance of performing the service $29 Required: Indicate the net effect of...
-
Answer the following about HeapSort related algorithms (max heap) How many times Heapify will be called in total (including recursive calls) if we call BuildHeap on the following array: A = [2, 3, 4,...
-
On 1 July 2018, Parent Ltd acquired all the shares of Son Ltd, on a cum-div. basis, for $2,057,000. At this date, the equity of Son Ltd consisted of: $ 1,000,000 Share capital 500 000 shares...
-
Comment on the following: If the financial statements contain an immaterial departure from generally accepted accounting principles, the auditors issue a qualified opinion; if the financial...
-
In designing further audit procedures, the auditors should assess the risks of material misstatement of the financial statements. a. Describe the auditors general approach to such risk assessment. b....
-
Do auditors usually begin their consideration of internal control over IT activities with a review of general or application control activities? Explain.
-
Stroboscope a. produces light pulses intermittently b. has high output and is insensitive to temperature c. frequently used in velocity pickups d. has high sensitivity and frequency range e....
-
The water tank shown in Fig. 14.33 is supported by a hollow circular steel column. The tank, made of steel, is in the form of a thin-walled pressure vessel and has a capacity of 40,000 litres. Design...
-
Using the third-order Runge-Kutta method, solve Problem 11.15. Data From Problem 11.15:- Using the second-order Runge-Kutta method, solve the differential equation \(\ddot{x}+1000 x=0\) with the...
Study smarter with the SolutionInn App