I have a database that I need someone to look over for me. It is a sample project manager database. It is filled it with sample data, and has a few queries, but I am having trouble with a few parts of it, and I was woundering if anyone would be able to double check my work and relationships. It is a small database, with only 8 tables. I uploaded a copy of it so if someone could take a quick look at it that would be great.
http://smoothdesigners.com/ProjectManager.zip
Also if you could IM me my screen name is j0hnbanks .
This what the queries are supposed to return.
Q1:A listing of projects, milestones, and status
(Can't get it correct, bad querie in place)
Q2:A listing of projects, milestones, lead employees, and status for those milestones not completed, grouped by project.
(Seems correct)
Q3:A listing of a project with milestone steps and status.
(Seems correct)
Thanks for any help that you can provide.
-John