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 agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.