Employee: (EID, Name, City, Address) Department: (DID, Department_Name, City, budget) Works_IN: (EID, DID, Annual_Salary, Start_Date) Manages: (ManagerID, DepartmentID, rank) DID and EID in Works_IN...

Extracted text: Employee: (EID, Name, City, Address) Department: (DID, Department_Name, City, budget) Works_IN: (EID, DID, Annual_Salary, Start_Date) Manages: (ManagerID, DepartmentID, rank) DID and EID in Works_IN relation are foreign keys referencing the primary keys of the Department and Employee relations respectively. Manager_ID and Department_ID in the Manages relation are foreign keys referencing the primary keys of the Employee and Department respectively. From the relational schemas illustrated above, use the different relational algebra operators and operations (p, o, n, N, U, -, X) discussed in class to build the following queries: Display employees (by name and address) from "Chicago" and with an annual salary between 60000 (included) and 90000 (excluded) then rename the output as "ChicagoEmployees" 1. 2. For each employee, who works in the “Design" department since January 2009, display the employee's name and the employee's annual salary 3. Find the name and rank of the manager who manages the “Research" department, also display the budget of that department. 4. Find the name of employees who earn more than $100,000 per year, along with the names of the departments they work in 5. Assume employees can work in more than one department, find employees (by name and salary) who work in the "Design" department but not the "Research" department.