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

a. Modify the database so that Jones now lives in Newtown.

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

c. Give all managers of First Bank Corporation a 10 percent raise.

d. Give all managers of First Bank Corporation a 10 percent raise unless the salary becomes greater than $100,000; in such cases, give only a 3 percent raisee.

e. Delete all tuples in the works relation for employees of Small BankCorporation.

employee (employee-name, street, city) works (employee-name, company-name, salary) mpany (compa-, ity) manages (employee-name, manager-name)