Question: employees( eid , ename, age, salary, address, years_of_experience, dname) departments( dname , location, manager_id, budget) projects( pname , location, start_date) works_on( eid, pname , hours)

employees(eid, ename, age, salary, address, years_of_experience, dname)

departments(dname, location, manager_id, budget)

projects(pname, location, start_date)

works_on(eid, pname, hours)

List the name of departments that have managers that make less than $75,000 and that have employees making more than $100,000

List the salary of the employees from the systems department that works on every project located in Madison (works on all projects)

List the name of the department on which all employees work on a project that started before 11-26-2020

List the ids and names of employees that work in a department located in Phoenix who have the same years of experience as their own manager

List the name of employees with less than five years of experience working on both a project located in Tucson and in a project located in San Francisco.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!