|
Post by jas389 on Oct 26, 2012 15:42:54 GMT -5
I am having trouble answering the SQL question "List all projects that have finished".
The information that is provided does not state the projects status. How should we determine if a project is complete?
|
|
|
Post by Bob P on Oct 26, 2012 16:05:20 GMT -5
Great question. Often times in database development there is incomplete information. you need to ask specifics of people in the company or the manager who will be using the system. In our system it's up to you how you want to handle it. You can have status checks or more simply the due date indicates when a project is done. So if the current date is past the project due date then we can assume the project is finished.
Bob
|
|