For the following relational schema:
Employee(employeeID, employee-name, street, city)
Works(employeeID, company-name, salary)
Company(company-name, city)
Manages(employeeID, managerID)
Write the following Queries:
1.1 Find the names, street address, and cities of residence forall employees who work for ‘First Bank Corporation’ and earn morethan $10,000.
1.2 Find the names of all employees in the database who live inthe same cities as the companies for which they work
1.3 Find the names of all employees in the database who live inthe same cities and on the same streets as do their managers
1.4 Find the names of all employees in the databasewho do not work for ‘First BankCorporation’. Assume that all peoplework for
OR
OR