Need fast help.

[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. 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

 

[neileg]

A few points:

You have a few fields called Name. This is bad because Name is a reserved word in VBA and it is also better to have distinct field names across your tables.

You have the Manager table linked to Project and to Milestone and Project and Milestone are linked. It's not obvious if this is valid.

Your relatiuonship between Project and Milestone is wrong. Because a Project can have many Milestones, you should hold the project ID in the Milestone table, not the other way round as it is now.

You don't need an employee table and a manager table. Merge them together. Either hold a field in this table that identifies a manager, or more likely just let the link to the manager field in the Project table define this for you. The project table should hold the manager id, not the other way round because a project will only have one manager but a manager can have more than one project (even if only one at a time).

Although I know a bit about project management, I don't follow your setup. What are Steps? Shouldn't milestones be connected to workstreams rather than the project? How can a milestone have a start and end date? Don't they have a planned date and an achieved date?

 

[PARSO]

i made some changes, see if any will help you?
i tryed 2 simplyfy the relationships as well. but maybe you had it the way you did for a reason?

 

[neileg]

Hey, PARSO, seems like the fast help was too fast!