relationships project

[holt1]

I have a database wtih three tables programmers,assignments, and projects.

Each programmer has a first name, lastname, address, and employeeid.

Each project has a projectid, project name, project description.

Each programmer is assigned zero or more projects, and each project can be completed by 1 or more programmers. Each assignment is placed appropriately into the assignment table
each record in the assignment table has a assignmentid and projectid and employeeid.
I am trying to form the relationships between these tables will all my relationship lines run through assignments can anyone tell me how to develop these relationships and if the many to many relationship of programmers to project runs through assignments
thanks I am new at this if this is unclear I can try to clarify

 

[Andrew Fergus]

Hi, I think I understand what you are asking - do you want to clarify how to set up a many-to-many relationship between the programmers and projects? If so, you are certainly on the right track.

Before you start, make sure the employee id and project id are set to be the keys in your employee and project tables. Also, do you need to have an assignment id in the assignment table? If you had just the employee id and project id in that table, and made both fields the key (highlight both and click the key symbol while in table design) then you can't inadvertently assign the same programmer to the same project twice.

Insofar as the relationships are concerned, under Tools -> Relationships, set up the relationships as follows :

Link the programmer id in the programmer table to the programmer id in the assignment table with a one-to-many relationship (one programmer to many assignments, enforce referential integrity and tick cascade update).

Link the project id in the project table to the project id in the assignment table with a one-to-many relationship (one project to many assignments, enforce referential integrity and tick cascade update).

Save the relationships.

This should give you the structure and set-up that should stand the test of time.

HTH, Andrew.

 

[holt1]

thanks andrew I am going to give it a look in the morning I sure appreciate the help. hope I can return the favor to another.