$1.$Write a procedure which accepts an employees identification number and returns back the employees full name and salary to the calling program.Write a simple anonymous block with the procedure call to test it$\mathrm{.}2.$Write a function and pass a department number to it$.$If the DEPT table does not contain that department number, return a FALSE value, otherwise return a TRUE value.Print the appropriate message in the calling program based on the result.Write a simple anonymous block with the function call to test it$\mathrm{.}3.$Write a function which returns the department name of a given employee id$.$The function accepts an employee id number as an input.If the given employee id exists, it returns the employees department name.If the employee id is invalid $($does not exist$),$ it returns NULL.Write a simple anonymous block with the function call to test it$\mathrm{.}4.$Write a procedure which accepts a department number and deletes the corresponding department from DEPT table.The procedure accepts a department number.If the department number exists, the procedure assigns the departments employees to NULL and then it deletes the department.If the department number does not exist, the procedure prints a descriptive text.Write a simple anonymous block with the procedure call to test it$.$