j0hnb

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

Bamrak

The relationships look good, here's your querys. it would also help to use a standard naming convention and give the query's descriptive names, or at least fill in the description. Your Queries are as follows:

Q1- you need a grouping to get rid of your duplicate rows.. like this:

SELECT Project.Name AS Project_Name, Milestone.Name AS Milestone_Name, Steps.Status_Complete
FROM (Milestone INNER JOIN Steps ON Milestone.MilestoneID = Steps.MilestoneID) INNER JOIN Project ON Milestone.MilestoneID = Project.MilestoneID
GROUP BY Project.Name, Milestone.Name, Steps.Status_Complete;

Q2- looks correct

Q3 also seems correct