Many-to-many with references in MongoDB - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a many-to-many relationship in databases?

A many-to-many relationship means that multiple records in one collection can relate to multiple records in another collection. For example, many students can enroll in many courses.

beginner

How do MongoDB references help model many-to-many relationships?

MongoDB uses references by storing the IDs of related documents in arrays. This way, documents can point to many others without duplicating data.

intermediate

Why use references instead of embedding for many-to-many relationships?

References avoid data duplication and keep documents smaller. Embedding many related documents can make documents too large and harder to update.

beginner

Example: How to store course IDs in a student document for many-to-many?

In the student document, include a field like enrolledCourses which is an array of course IDs. Each ID references a course document.

intermediate

What is a common pattern to query many-to-many references in MongoDB?

First, find the document with the array of IDs, then use those IDs to query the related collection. This is called manual referencing or client-side join.

In MongoDB, how do you represent a many-to-many relationship?

A By creating a single document for all relationships

B By embedding all related documents inside one document

C By storing arrays of referenced document IDs in both collections

D By using SQL JOIN statements

MongoDB uses arrays of referenced IDs in documents to represent many-to-many relationships.

Why might embedding not be ideal for many-to-many relationships?

A It duplicates data and can make documents too large

B It is faster than referencing

C It automatically updates related documents

D It is required by MongoDB

Embedding duplicates data and can cause large documents, which is not efficient for many-to-many.

What field type is commonly used to store references in MongoDB?

A Number

B Array of ObjectIds

C Boolean

D String

References are stored as arrays of ObjectIds pointing to related documents.

How do you retrieve related documents in a many-to-many setup in MongoDB?

A Use SQL JOIN to combine collections

B Use map-reduce functions only

C Embed all related documents in one query

D Query the IDs stored in the array and fetch related documents separately

You query the array of IDs and then fetch related documents in separate queries.

Which of the following is NOT a benefit of using references for many-to-many?

A Automatically enforces foreign key constraints

B Keeps documents small

C Avoids data duplication

D Allows flexible relationships

MongoDB does not automatically enforce foreign key constraints with references.

Explain how to model a many-to-many relationship using references in MongoDB.

Think about how two collections can point to each other using IDs.

Describe the steps to query related documents in a many-to-many relationship with references in MongoDB.

Remember MongoDB does not do automatic joins like SQL.