7.9. Consider the following view, DEPT_SUMMARY, defined on the COMPANY database in Figure 5.6: CREATE VIEW DEPT_SUMMARY (D, C, Total_s, Average_s) AS SELECT FROM GROUP BY Dno, COUNT (), SUM (Salary), AVG (Salary) EMPLOYEE Dno State which of the following queries and updates would be allowed on the view. If a query or update would be allowed, show what the correspond- ing query or update on the base relations would look like, and give its result when applied to the database in Figure 5.6. a. SELECT FROM DEPT_SUMMARY; b. SELECT D, C FROM DEPT_SUMMARY WHERE TOTAL S 100000