Consider the following view, DEPT_SUMMARY, defined on the COMPANY database IN Figure 3.6:

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 corresponding query or update on the base relations would look like, and give its result when applied to the database of Figure 3.6.

Figure 3.6

  

 

Transcribed Image Text:

CREATE VIEW DEPT SUMMARY (D. C. TOTALS, AVERAGE_S) AS SELECT DNO, COUNT ("), SUM (SALARY), AVG (SALARY) FROM EMPLOYEE GROUP BY DNO: CREATE VIEW DEPT SUMMARY (D. C. TOTALS, AVERAGE_S) AS SELECT DNO, COUNT ("), SUM (SALARY), AVG (SALARY) FROM EMPLOYEE GROUP BY DNO: