Check my Relationships

[lcook1974]

Good afternoon everyone,
Could I get someone to check my relationships? See attached picture...

What I am tasked to do is create a PDSA database... (Plan, Do, Study, Act)

For Every problem there can be "many" cycles
For Every Cycle there can be "many" Plans
For Every Plan there can be "many" Dos
For Every Do there can be "many" studies
For Every Study There can be "many" Acts

The example given to me had a life time of over a year with 7 different cycles and lots of "plans".

My goal is to create the tables on my SQL server then have Access as a front end to allow the users in the office to access it easily.

Please let me know if you need more information, and/ or suggestions on what I can do to improve this design.

I want to get it as close to "perfect" before I start any thing else..

Thanks!
Larry

 

[lcook1974]

I think I put this in the wrong section...Should it be under Theory and Practice? how do I move it?

Thanks! whoever moved it...

 

[boblarson]

I think I put this in the wrong section...Should it be under Theory and Practice? how do I move it?

Normally you would use the Report button (red triangle with exclamation mark) to let the admins/mods know and we would move it. But I've already done so.

As for the design, the first thing I see that needs fixing is your team table. You should not have repeating fields TeamMember1, TeamMember2, etc.

You would have a Team table and a Members table and then you would have a junction table for the members to be assigned to the team.

 

[lcook1974]

Okay...corrected that. I'll have that connected to my contacts table (another DB).