in Databases
535 views
0 votes
0 votes
Consider the relational database shown below. Give an expression in the
relational algebra to express each of the following queries:
a. Find the names of all employees who work for “First Bank Corporation”.
b. Find the names and cities of residence of all employeeswho work for
“First Bank Corporation”.
c. Find the names, street address, and cities of residence of all employees
who work for “First Bank Corporation” and earn more than $10,000.

 

employee (person name, street, city)
works (person name, company name, salary)
company (company name, city)
in Databases
535 views

Please log in or register to answer this question.

Related questions