109k views
0 votes
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.

User Braddock
by
6.3k points

1 Answer

4 votes
Check the attached files for the solution.
Exercise 21.2 you are the dba for the veryfine toy company and create a relation called-example-1
Exercise 21.2 you are the dba for the veryfine toy company and create a relation called-example-2
User Ivan Peric
by
7.0k points