Consider the relational database of Figure. Give expressions in QBE 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 in the database a 10 percent raise.

d. Give allmanagers in the database a 10 percent raise, unless the salarywould be greater than $100,000. In such cases, give only a 3 percent raise.?

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

Transcribed Image Text:

employee (person-name, street, city) works (person-name, company-name, salary) соmpаny (cоmpamу-пате, city) manages (person-name, manager-name)