Consider the relational database of Figure. Give an expression in the relational algebra for each request:

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

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

c. Give all managers in this database a 10 percent salary raise.

d. Give allmanagers in this database a 10 percent salary raise, unless the salary would 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 Bank Corporation

Transcribed Image Text:

employee (person-name, street, city) works (person-name, company-name, salary) соmрany (companу-пamе, city) таnages (person-нате, тапager-nате)