rdholdford
Technical User
I am developing or rather amending an existing database for a non-profit and I am having difficulty visualizing table relationships
The agency wants one master database. It has 12 programs (may add more) that serve families to prevent child abuse/neglect. Families can have members that are clients or non clients. Client can be pending, active or closed in multiple programs with varying open and closed dates
The current version has two main tables, FAMILY – which includes a Family ID field case name and demographic and contact data and CHILDREN – which includes some demographic data on each child. These tables are related, one to many, with FAMILY being the “parent”. Each of these tables also has a “child’ table, FAMILY SESSIONS and CHILD SESSIONS.
The problem is the agency has 12 programs. Some focus on adults, some focus on kids and some focus on families. I must keep track of adults and children and various demographics with participation in sometimes multiple programs with various participation dates and case status information (pending, open, closed). I must also track for each program and for the agency as a whole
Families can have many members. Members can be in many programs. Programs can have many members. It seems I need a PROGRAM table but I’m not clear on how the tables should be related. Thanks
The agency wants one master database. It has 12 programs (may add more) that serve families to prevent child abuse/neglect. Families can have members that are clients or non clients. Client can be pending, active or closed in multiple programs with varying open and closed dates
The current version has two main tables, FAMILY – which includes a Family ID field case name and demographic and contact data and CHILDREN – which includes some demographic data on each child. These tables are related, one to many, with FAMILY being the “parent”. Each of these tables also has a “child’ table, FAMILY SESSIONS and CHILD SESSIONS.
The problem is the agency has 12 programs. Some focus on adults, some focus on kids and some focus on families. I must keep track of adults and children and various demographics with participation in sometimes multiple programs with various participation dates and case status information (pending, open, closed). I must also track for each program and for the agency as a whole
Families can have many members. Members can be in many programs. Programs can have many members. It seems I need a PROGRAM table but I’m not clear on how the tables should be related. Thanks