figure 2.35

employee(person_name, street, city)

works(person_name, company_name, salary)

company(company_name, city)

manages(person_name, manager_name)

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

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

b. Give all managers 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.

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