Consider the relational database of Figure. Using SQL, define a view consisting of manager-name and the average salary of all employees who work for that manager. Explain why the database system should not allow updates to be expressed in terms of this view.

Transcribed Image Text:

employee (employee-name, street, city) works (employee-name, company-name, salary) соmpany (compaу-пате, сity) manages (employee-name, manager-name)