I am a teacher constructing a site for tracking test results, but cannot get my head around the relationships.
I am envisioning a schema that has students these have many results and a test also has many results. Therefore students should have many tests through many results?
Additionally students will have many classes so there is a group_student pivot table.
How would I call principally all student results for a test where group = foobar?
Is there not an easy way to construct multiple nested relationships in laravel or is this unnecessary and I should just be retrieving each set in turn.
I have made a provisional "map" on laravelsd available:
Any help would be greatly appreciated,