Consider the following view, DEPT_SUMMARY, defined on the COMPANY database in Figure 5.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 in Figure 5.6.

Figure 5.6

Transcribed Image Text:

a. SELECT FROM DEPT SUMMARY; b. SELECT D, C DEPT_SUMMARY TOTAL_S>100000; FROM WHERE