CREATE TABLE DEPT (DEPT_ID INT(2), DNAME VARCHAR(14), LOC VARCHAR(15), DATE_INSERTED DATE, DATE_LASTUPDATED DATE, PRIMARY KEY(DEPT_ID)); CREATE TABLE SALGRADE (GRADE_ID INT(3), LOSAL NUMERIC
(7,2)
, HISAL NUMERIC
(7,2)
, PRIMARY KEY(GRADE_ID)); CREATE TABLE EMP (EMP_ID INT(4), E_LAST_NAME VARCHAR(20), E_FIRST_NAME VARCHAR(15), JOB VARCHAR(9), MGR_ID INT(4), HIREDATE DATE, SAL NUMERIC(7,2), GRADE_ID INT(3), COMM NUMERIC
(7,2)
, DEPT_ID INT(2), DATE_INSERTED DATE, DATE_LASTUPDATED DATE, PRIMARY KEY(EMP_ID), FOREIGN KEY (DEPT_ID) REFERENCES DEPT(DEPT_ID), FOREIGN KEY (GRADE_ID) REFERENCES SALGRADE(GRADE_ID)); Create a procedure that has one input parameter a value for MGR_ID, and an out parameter to return the employee id with the oldest hire date for that manager (so the most senior employee that reports to that manager). You will have to do a little research on the output parameter and how to use it.