This is an ERD I've put together as the initial structure for a martial arts or dance type school. One person could have multiple schools, each school multiple students, etc. One schedule per school.

Where I need clarification is that a member can be a parent, student or both. With the possibility of having multiple parents, I put the relations into an association table. I'm not sure how to represent that on the ERD, nor am I certain how to represent the relationships between students, schools and class attendance. (Nor am I sure that this is the best design). I'd like an assessment of the design and clarification on the relationships between the tables.

enter image description here

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.