552 views
0 votes
0 votes
Consider the relational database given below Give an expression in SQL
for each of the following queries.
a. Modify the database so that “Jones” now lives in “Newtown”.
b. Give all managers of “First Bank Corporation” a 10 percent raise
unless the salary becomes greater than $100,000; in such cases, give
only a 3 percent raise.

employee (employee name, street, city)
works (employee name, company name, salary)
company (company name, city)
manages (employee name, manager name)

Please log in or register to answer this question.

Related questions