Consider the employee database of Figure 3.19. Give an expression in SQL for each of the following queries.

a. Give all employees of “First Bank Corporation” a 10 percent raise.

b. Give all managers of “First Bank Corporation” a 10 percent raise.

c. Delete all tuples in the works relation for employees of “Small Bank Corporation”.

Figure 3.19

Transcribed Image Text:

employee (ID, person_name, street, city) works (ID, company_name, salary) company (company_name, city) manages (ID, manager_id)