Question: I need help please E3 Mysql Program Design Experimental Objective You are required to utilize the following SQL operations expertly under Mysg platform Experimental Requirement
E3 Mysql Program Design Experimental Objective You are required to utilize the following SQL operations expertly under Mysg platform Experimental Requirement 1.Basic Hardware Configuration: Intel Pentiumillor above, Greater than 512MB memory 2. Software Requirement: Mysq 3. Hours: 2h 4 Experiment Report after Experiment Problem 1. A block of code is required to get the number of employees according to the input variabe deptcode. use example set deptcode-1i set Opersonnum0 select count(") into epersonnum from emp where dept no 9 deptcode select personnum Problem 2. Write a code block contains part of the definition, execution and exception handling: according to the empno of employee, output the employees name, salary and department name: if the inputted employee does not exist, then output error message. Problem 3. Write a block of code, according to the parameter of the employee number (empno), get his annual income and print it. Problem 4. Wri te a code block containing part of the definition, execution and exception handling, which realizing the following function: according to the department number output the names, salaries of all employees in this department. If the department does not exist, outputting error message
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
