Data base for community health mentoring management system

This is the database project for community health mentoring management system under this include the relational schema, entity attributes.
There are ten entity with attributes for each this are
Community health mentoring management system ER diagram
1. Community Health Mentors(C_H_MENTOR)
- MENTOR ...

This is the database project for community health mentoring management system under this include the relational schema, entity attributes.
There are ten entity with attributes for each this are
Community health mentoring management system ER diagram
1. Community Health Mentors(C_H_MENTOR)
- MENTOR :who provide guidance and support to community members in improving their health.
Attributes : mentor id(pk),
mentor name ,
mentor address,
phone _number
RELETIONSHIP : one to many with program and education material.
2. Community Members:
- C_MEMBER individuals within the community who seek health-related assistance.
Attributes: member id(pk),
member name,
member address ,
phone number.
RELETIONSHIP: many to many with education material and one to many with program participant.
3. Health Education Materials:

- MATERIAL: is the various educational resources available for community members to learn about health.

Attributes: material id(pk),

material type,
material type
RELETIONSHIP : many to one with training program and community member.
4. Training Programs(PROGRAM):
- Training PROGRAM: conducted for community members to enhance their health knowledge and skills.
Attributes: Program id(pk),
program trainer,
program title
RELETIONSHIP : one to many with participant.
5. Evaluation System:
- The EVALUATION process of community health programs to measure their effectiveness.
Attributes: evaluation id(pk),
evaluation date,
evaluation result,
evaluation type
RELETIONSHIP : one to one with participant.