Relational Algebra and SQL Fun

Consider the relation schemas as follows.

works(person_name, company_name, salary);
lives(person_name, street, city);
located in(company_name, city);
managers(person name, manager_name);

where manager name refers to person name.

• Find the names of the persons who work for company ’FBC’ (company name=’FBC’).
• List the names of the persons who work for company ’FBC’ along with the cities they live in.
• Find the persons who work for company ’FBC’ with a salary of more than 10000. List the names of these persons along with the streets and cities where they live.
• Find the names of the persons who live and work in the same city.
• Find the names of the persons who live in the same city and on the same street as their managers.
• Find the names of the persons who do not work for company ’FBC’.
• Find the persons whose salaries are more than the salary of everybody who work for company ’SBC’.
• Find the names of the companies that is located in every city where company ’SBC’ is located in.