Consider the following relations and write down expressions for the following queries:
EMP (eid, ename, age, address, salary)
Works (eid, did, hours)
Dept (did, dname, managerid)
- List the names of employees who work for the ‘Research’ department for 8 hours using Relational Algebra.
- List the name and address of all employees with department number 5 using Relational Calculas.
- Find the managerid of managers who manage only departments with budgets greater than 1 lac using SQL.
- Find the employee who has highest salary using SQL.
