Consider the relational database of Figure. Give expressions in QBE for each of the following queries: a.

Question:

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.

image

Corporation
A Corporation is a legal form of business that is separate from its owner. In other words, a corporation is a business or organization formed by a group of people, and its right and liabilities separate from those of the individuals involved. It may...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

Question Posted: