I’m not an intermediate here, and barely even a beginner (this is my first ever post I think)…
But have you considered possible data leakage in this solution? Will there be guardrails so Parent X can’t look up the marks and report cards of the children of Parents A, B, C?
I’m sure you’ve likely thought about this, but this was just the first thing that popped in my head when I read this thread. Wish you all the best, and I hope the solution comes out awesome for the school, parents and students.