Re: newbie question

Hi

We generally don't encurage homework solving in this conference.

/Joachim
Nick Carter wrote in message ...
>Hello netters,
>
>I have a newbie question to ask, hopefully someone can help me.
>
>I have the following relations and entity tables:
>
>employees(ename,ssn,address) key: (ssn)
>departments(dname,did,mgr_ssn) key: (did)
>works_on(ssn,pno,hours) key: (ssn,pno)
>projects(pname,pno,did) key: (pno)
>dependencies(ssn,depname,age,relationship) key:(ssn,depname)
>
>I need to create SQL statements for the following queries:
>
>a) Find all employees who have two dependents of the same age.
>b) List all employees who work in a department managed by Anna Perks.
>c) List all projects which are worked on by all employees.
>d) List all employees who do not work on any project.
>e) For every employee who works on a project, list his/her name and
> the total hours s/he spends on all projects.
>f) Find all projects that have the largest number of employees
> working on them.
>
>I am very new to SQL and have problems creating queries for the
>above. Hopefully some smart folks out there can help me.
>
>Thanks in advance,
>Nick
Received on Tue Nov 03 1998 - 02:40:22 CST