cs 411-01 Database Management System Design Test 3 Spring 2018 5. (20 points) Consider the following view DEPT_SUMMARY, defined on the COMPANY database: V1: CREATE VIEW AS SELECT DEPT SUMMARY (D, C, TOTAL s, AVERAGE_S) DNO, coUNT,SUM (SALARY),AVG (SALARY) FROM GROUP BY DNO; A. (10 points) Write below (in English) what the following view query posed against the above view DEPT SUMMARY does (i.c., formulate the query in English): QV1: SELECT FROM WHERE D, C, AVERAGES DEPT SUMARY C 3 B. (10 points) Write below (in SQL) the query on the base relation(s)', corresponding to the view query QV1, shown above