Question

Create the following tables with given attributes having appropriate data type and specify the necessary primary and foreign key constraints: Employee (Empld, Empname, Sai, Deptno) Dept (Deptno, Dname, Loc,Deptmanagerid) a) List the count of Employees and average salary of each department b) Listhe employee name, department name and the salary of all the employees. c) Display the Employee name and the respective department manager name. d) Create a function to return the salary of the employee when Empidis given as inout parameter Handle Exceptions.​

Answer 1

are you kidding me bhai itna bada question