NOSQL - how would you handle this?

Posted 03 July 2012 - 08:34 AM

Hey guys,

Right now I'm learning about NOSQL for work, and I'm thinking about how it would relate to an earlier project I've worked on. Imagine there was a database holding student records. Some of these students were also tutors, and this database also has a table that holds tutoring session records. So the tables might look something like this

Student Table

id
name

Subject Table

subject name

tutoring session

tutorer's ID
learner's ID
subject

I'm trying to get my mind into a NOSQL mentality. I know this is NOT the way you'd do something like this in a nosql environment, but how would you mimic it? The benefit is that using the session table, you can get all the tutoring or learning records of a given student from their ID. To do something like this in NOSQL, would you have to put the data for a given tutoring session onto two student entries?

This post has been edited by atraub: 03 July 2012 - 08:35 AM