Question

Exercise 21.2 you are the dba for the veryfine toy company and create a relation called employees with fields ename, dept, and salary. for authorization reasons, you also define views employeenames (with ename as the only attribute) and deptinfo with fields dept and avgsalary. the latter lists the average salary for each department.

Answer 1

Check the attached files for the solution.