Consider the relational database of Figure Give expressions in
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.

Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help