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.

  • CreatedJanuary 28, 2011
  • Files Included
Post your question