I am new to NoSQL and I am trying mongodb. I came from a relational database background and I need to be able to join or aggregate rows from 3 collections. The Student collection contains IDNum, Name, etc. the Books collection contains ISBN, Title, Edition, etc. and the ReservedBooks collection contains the IDNum of the student and the ISBN of the book.
Here are my inquiries:
-How would I go about retrieving all the reserved books of a certain student?
-Can I return all students with reserved books?
-Do I need to modify my student collection such that it will contain an array which will store the ISBNs of the reserved books?
Thank you in advance!