374 views
1 votes
1 votes
Consider the relational database given below. Give an expression in SQL
for each of the following queries.
a. Give all employees of “First Bank Corporation” a 10 percent raise.
b. Give all managers of “First Bank Corporation” a 10 percent raise.
c. Delete all tuples in the works relation for employees of “Small Bank
Corporation”.

here is the database

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

0 votes
0 votes
1 answer
1
ajaysoni1924 asked Mar 30, 2019
688 views
Rewrite the where clausewhere unique (select title from course)without using the unique construct.
0 votes
0 votes
0 answers
4