Question

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 BankCorporation.



$1.99
Sales1
Views384
Comments0
  • CreatedJanuary 28, 2011
  • Files Included
Post your question
5000