(a) Explain how a stored procedure is processed by the DBMS query processor (including the type of return value after the query is processed) (b) Briefly explain difference between stored procedure and stored function (c) Explain tasks performed by the following event DELIMITER // CREATE EVENT work_on_info_update ON SCHEDULE AT NOWO + INTERVAL 1 MONTH DO BEGIN delete from works_on_info; insert into works_on_info(Emp_name, Proj_name, Hours_per_week) select E.Lname, P.Pname, W.Hours from project P, works on W, employee E where P.pnumber-W.pno and W.essn-E.ssn; END // DELIMITER; (d) Explain when the following trigger is fired, and explain the task performed by the trigger DELIMITER // CREATE TRIGGER dnameBefore Update BEFORE UPDATE ON department FOR EACH ROW BEGIN SET NEW.dname= Lower(NEW.dname); END// DELIMITER; UPDATE department SET dname = 'Research Department 2' WHERE dnumber = 5; select * from department where dnumber = 5; update department set dname 'Research Dept' where dnumber= 5;