I am looking to implement a new database and store students exam data and marks in the database. There are an arbitrary number of students and each student has an arbitrary number of modules with corresponding marks. I need the database(MongoDB) to be created so that I am able to query the database and return the students name followed by each of their modules and corresponding marks and then to move onto the next student. This is because I want to display it in NodeJs an with a list of students names in bold and then marks for each course, position for each course, overall total scores and overall average(%).

I initially considered to organise the table like this:

| S/N | StudentName | score 1 | score 2 | ... | GRAND TOTAL | AVERAGE | POSITION |

With a new entry for each module that the student takes and just store multiple students but then I do not know how I would then query the database and retrieve each StudentName individually and then be able to loop through their corresponding modules and results to store it in an HTML table.

Any ideas would be appreciated