Question: Need help with e-g please Consider the following relational database: 1. Consider the following relational database: - lives(person-name, street, city) works(person-name, company-name, salary) -located-in(company-name, city)
Consider the following relational database: 1. Consider the following relational database: - lives(person-name, street, city) works(person-name, company-name, salary) -located-in(company-name, city) manages(person-name, manager-name) Give an expression in the relational algebra for each of the queries below a. Find the name of all people who work for First Bank Corporation. Find the name and city of all people who work for First Bank Corpora- tion. . Find the name, street, and city of all people who work for First Bank Corporation and earn more than $10,000. d. Find all people who live in the same city as the company they work for. e. Find all people who live in the same city and on the same street as their manager. f. Find all people who do not work for First Bank Corporation. 8. Find all people who earn more than every employee of Small Bank Corpo- ration. h. Assume the companies may be located in several cities. Find all companies located in every city in which Small Bank Corporation is located
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
