Creating Stored Procedures

$$

Write a stored procedure called $`$pro$\_$view$\_$employee$`$ that accepts an employee ID as an input parameter and retrieves the employee's last name, first name, salary, job title, and department name.

$$

Write a stored procedure called $`$pro$\_$update$\_$Commission$`$ that accepts input parameters for employee ID and commission percent, and updates the commission percent for the specified employee ID$.$

$$

Write a stored procedure called $`$pro$\_$insert$\_$department$`$ that accepts input parameters for department ID and department name, and inserts a new record into the department table.

$$

Write a procedure called $`$pro$\_$number$\_$of$\_$employee$`$ that, given a department ID$,$ displays the department name and the total number of employees in that department.