Reference no: EM133246007
Question 1.
"employee (person_name, street, city)
Works (person_name, company_name, salary)
Company (company_name, city)
Figure 2.17Employee database" for Bigbank
"Consider the employee database of Figure 2.17. Give an expression in the relational algebra to express each of the following queries:
a. Find the name of each employee who lives in city "Miami".
b. Find the name of each employee whose salary is greater than $100000.
c. Find the name of each employee who lives in "Miami" and whose salary is greater than $100000."
Question 2.
"Consider the employee database of Figure 2.17. Give an expression in the relational algebra to express each of the following queries:
Find the ID and name of each employee who does not work for "Big Bank"
Find the ID and name of each employee who earns at least as much as every employee in the database."
Question 3.
"Consider the employee database of Figure 2.17. Give an expression in the rela-tional algebra to express each of the following queries:
Find the ID and name of each employee who works for "BigBank".
Find the ID, name, and city of residence of each employee who works for "BigBank".
Find the ID, name, street address, and city of residence of each employee who works for "Big Bank" and earns more than $10000.
Find the ID and name of each employee in this database who lives in the same city as the company for which she or he works."