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.
Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.