Suppose XYZ Corp. is an IT service providing company. Employee details of the company are stored...

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