adm88
New Member
Posts: 10
|
Post by adm88 on Oct 23, 2012 19:16:15 GMT -5
NOTE: I didn't know where I should put this post, if it's more appropriate in HW7 could you move it there? Could you please clarify what exactly you want these statements to do: List the depts. of all the employees working on a project List the depts. of all employees not working on a project by "working on a project" you mean a particular project, or you want departments of all employees working on at least one project List employees who are free to work on a project when an employee is free to work on a project? List all projects that have finished is a project finished when it's after past due, or should we add another column with progress status? Thank you?
|
|
|
Post by Bob P on Oct 23, 2012 21:36:17 GMT -5
Working on a project means any project. So if I was a manager it would valuable for me to know what employees are available to be assigned a project or which departments are not involved in a project in case I have one available.
An employee is free if they are currently not working (assigned) on a project. If they were assigned and the the due date is pass then they are free too.
Lets assume that once the due date hits the project is done - not exactly real world but makes programming easier.
Bob
|
|