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

I need help please  I need help please E3 Mysql Program Design Experimental Objective You

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!