Reference no: EM132227205

Give the following relational database: Emp(eid: integer, ename: string, age: integer, salary: real), Works(eid: integer, did: integer, pct_time: integer), Dept(did: integer, dname: string, budget: real, managerid: integer) Assume that an employee can work in more than one dept; the pct_time field of the Works relation shows the percentage of time that a given employee works in a given department. Write the following queries in SQL: 1. Find the name of each employee whose salary exceeds twice the budget of all of the department of each of the department that he/she works in. 2. Find the managerids of managers who manage only departments with budgets greater than $5,000,000. 3. Find the enames of managers who manage the departments with the smallest budget. 4. If a manager manages more than one department, he/she controls the sum of all the budgets for those departments. Find the managerids of the managers who control more than $6,000,000 and less than $10,000,000. 5. For each department with more than 30 full-time-equivalent employees (i.e., where the part-time and full-time employees add up to at least that many full-time employees), find the did together with the number of employees that work in that department.