Can You

Question

Can You

help me to find the relational algebra for these three queries f, g, and h

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:
f. Find all people who do not work for First Bank Corporation.
g. 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.Engineering Technology