sql join queries

April 26, 2010 at 07:24:17
Specs: Windows 7
can somebody help me regaring sql join multiple tables queries?

Given the following Schema, answer the following queries:
employee(fname, minit, lname, ssn, bdate, address, sex, salary, superssn, dno)
department(dname, dnumber, mgrssn, mgrstartdate)
dept_locations(dnumber, dlocation)
project(pname, pnumber, plocation, dnum)
works_on(essn, pno, hours)
dependent(essn, dependent_name, sex, bdate, relationship)

7. Retrieve the name and address of all employees who work for the
'Research' department.
8. For every project located in 'Stafford', list the project number, the
controlling department number, and the department manager's last name,
address, and birthdate.
9. Find the names of employees who work on all the projects controlled
by department number 5.
10. Make a list of project numbers for projects that involve an employee
whose last name is 'Smith', either as a worker or as a manager of the

See More: sql join queries

May 7, 2010 at 18:34:07
You know, I don’t mind helping people with their homework, but I find it disrespectful when someone posts their entire assignment with the expectation of someone completing it for them.

If you desire to work in this field, you need to be able to do the work yourself. In other words, work through the problem, and then post specific issues that you cannot figure out. To ask someone to complete your assignment, without effort on your part, is a waste of both of our time.

Report •
Related Solutions

Ask Question