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.