Question

Create the following tables with given attributes having appropriate data type and specify the
necessary primary and foreign key constraints:
Employee (Empld. Empname. Sal Deptno)
Dept Deptno Dname, Loc. Deptmanageria)
a) List the count of Employees and average salary of each department
b) List the 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 Empid is given as input parameter
Handle Exceptions

Answer 1

PLEASE MARK BRAINLIEST

PLEASE GIVE ME THANKS

Answer 2

Answer:

kxbevwbix

Explanation:

evivxebkeb3 cricbixbeixikxbwkwwbixekvxiwx