Personally I think a graphing database like Neo4j would be great for this, you could have Student nodes with properties such as name, grade, age, etc... and you could create test nodes for each test with properties such as subject, length, type (quiz, test, etc...), etc... and you could then attach the students to nodes with relationships such as tested with properties on the relationships such as score, pass status etc... Using the student to test relationships you could calculate average score per test, even score per test per subject or type, average pass/fail rate, and you could use the test nodes to evaluate the relationship properties by average pass/fail per test rate, etc...
Hope this helps. Personally I find the graphing nature of Neo4j to be much more flexible for modification if you need to add properties or different relationship types than your typical RDBMS such as MySQL. I was using MySQL for some of our previous projects but we then had to run the results through other analytic engines to gain the graphing relations anyway, so with Neo4j you can move a lot of that work directly into the database using Cypher. Best of luck. On Wednesday, December 18, 2013 12:07:16 PM UTC, Hetul Kothari wrote: > > I am working on a project for preparing report cards for students and > running some basic computations like averages, comparisons etc... > > As an example, I have list of students studying in different classes > (Grade 1 to Grade 10) having a bunch of subjects and they are being > accessed for many tests for each of the subjects throughout the year... > > At the moment I am using a mysql db but I am evaluating if I could get the > same done using a GraphDB like Neo4j? I am just looking for pointers at the > moment... If it is possible, I can devote more time to go through the > documentation and learning it.. but for now I just need help evaluating > this... > > hk > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
