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
- subject name
- tutorer's ID
- learner's ID
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