asked 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.

asked
User Braddock
by
7.8k 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
answered
User Ivan Peric
by
8.2k points
Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.