Insert with nested documents in MongoDB - Mini Project: Build & Apply

Insert with Nested Documents in MongoDB

📖 Scenario: You are managing a small library database. Each book has a title, author, and details about its publisher. The publisher information includes the name and address, which is a nested document.

🎯 Goal: Create a MongoDB document for a book that includes nested publisher details, and insert it into the books collection.

📋 What You'll Learn

Create a document with fields title, author, and publisher

The publisher field must be a nested document with name and address

Insert the document into the books collection

💡 Why This Matters

🌍 Real World

Nested documents are common in MongoDB to represent related data in one place, like a book and its publisher.

💼 Career

Understanding nested documents and insert operations is essential for working with MongoDB in real-world applications.

1

Create the book document

Create a variable called book that holds a document with title set to "The Great Gatsby" and author set to "F. Scott Fitzgerald".

MongoDB

# Your code here

Hint

Use curly braces to create a document. Add title and author as keys with their values.

2

Add nested publisher document

Add a publisher field to the book document. This field should be a nested document with name set to "Scribner" and address set to "123 Publisher St".

MongoDB

book = {
    "title": "The Great Gatsby",
    "author": "F. Scott Fitzgerald"
}
# Add the nested publisher document here

Hint

Inside the book dictionary, add a key publisher with another dictionary as its value.

3

Insert the document into the collection

Use db.books.insertOne(book) to insert the book document into the books collection.

MongoDB

book = {
    "title": "The Great Gatsby",
    "author": "F. Scott Fitzgerald",
    "publisher": {
        "name": "Scribner",
        "address": "123 Publisher St"
    }
}
# Insert the book document into the books collection

Hint

Use the insertOne method on the books collection to add the document.

4

Verify the insertion with a query

Write a query using db.books.findOne({"title": "The Great Gatsby"}) to retrieve the inserted document.

MongoDB

book = {
    "title": "The Great Gatsby",
    "author": "F. Scott Fitzgerald",
    "publisher": {
        "name": "Scribner",
        "address": "123 Publisher St"
    }
}
db.books.insertOne(book)
# Query to find the inserted book document

Hint

Use findOne with a filter on title to get the document.

Practice

1. What is the main purpose of using nested documents in MongoDB inserts?

easy

A. To create multiple collections at once

B. To group related data inside one record

C. To speed up query execution automatically

D. To enforce strict schema validation

Solution

1. Step 1: Understand nested documents concept

   Nested documents allow storing related data together inside a single MongoDB document using curly braces { }.

2. Step 2: Identify the purpose of grouping data

   This grouping helps keep related information organized and easy to access in one record.

3. Final Answer:

   To group related data inside one record -> Option B

4. Quick Check:

   Nested documents = Group related data [OK]

Hint: Nested documents group related info inside one record [OK]

Common Mistakes:

• Thinking nested documents create multiple collections
• Assuming nested documents speed up queries automatically
• Confusing nested documents with schema enforcement

2. Which of the following is the correct syntax to insert a nested document using insertOne in MongoDB?

easy

A. db.collection.insertOne({name: "Alice", address: {city: "NY", zip: 10001}})

B. db.collection.insertOne([name: "Alice", address: {city: "NY", zip: 10001}])

C. db.collection.insertOne({name: "Alice", address: [city: "NY", zip: 10001]})

D. db.collection.insertOne({name: "Alice", address: "city: NY, zip: 10001"})

Solution

1. Step 1: Check the correct use of curly braces for nested documents

   Nested documents must be inside curly braces { }, not square brackets [ ].

2. Step 2: Verify the overall insertOne syntax

   The insertOne method takes a single document object with key-value pairs, including nested documents correctly enclosed in braces.

3. Final Answer:

   db.collection.insertOne({name: "Alice", address: {city: "NY", zip: 10001}}) -> Option A

4. Quick Check:

   Curly braces for nested docs + insertOne syntax = db.collection.insertOne({name: "Alice", address: {city: "NY", zip: 10001}}) [OK]

Hint: Use curly braces { } for nested docs inside insertOne [OK]

Common Mistakes:

• Using square brackets instead of curly braces for nested docs
• Passing an array instead of an object to insertOne
• Putting nested data as a string instead of an object

3. Given the following insert command, what will be the stored document in the collection?

db.users.insertOne({name: "Bob", contact: {email: "[e-mail]", phone: "123-456"}})

medium

A. { "name": "Bob", "contact": { "email": "[e-mail]", "phone": "123-456" } }

B. { "name": "Bob", "contact.email": "[e-mail]", "contact.phone": "123-456" }

C. { "name": "Bob", "contact": [ "email", "phone" ] }

D. { "name": "Bob", "email": "[e-mail]", "phone": "123-456" }

Solution

1. Step 1: Understand how nested documents are stored

   The nested document under 'contact' is stored as a sub-document with keys 'email' and 'phone'.

2. Step 2: Compare options with expected nested structure

   Only { "name": "Bob", "contact": { "email": "[e-mail]", "phone": "123-456" } } correctly shows 'contact' as an object containing 'email' and 'phone' keys.

3. Final Answer:

   { "name": "Bob", "contact": { "email": "[e-mail]", "phone": "123-456" } } -> Option A

4. Quick Check:

   Nested document stored as object = { "name": "Bob", "contact": { "email": "[e-mail]", "phone": "123-456" } } [OK]

Hint: Nested documents appear as objects inside main document [OK]

Common Mistakes:

• Flattening nested keys incorrectly
• Using arrays instead of objects for nested data
• Placing nested fields at top level

4. Identify the error in this MongoDB insert command:

db.products.insertOne({name: "Pen", details: [color: "blue", price: 1.5]})

medium

A. Missing comma between fields in main document

B. Missing quotes around field names

C. Using square brackets instead of curly braces for nested document

D. insertOne cannot insert nested documents

Solution

1. Step 1: Check syntax for nested documents

   Nested documents must use curly braces { }, but here square brackets [ ] are used incorrectly.

2. Step 2: Confirm other syntax elements are correct

   Field names are quoted correctly or allowed without quotes, and commas are present; insertOne supports nested docs.

3. Final Answer:

   Using square brackets instead of curly braces for nested document -> Option C

4. Quick Check:

   Nested docs need { }, not [ ] [OK]

Hint: Nested docs require curly braces { }, not square brackets [ ] [OK]

Common Mistakes:

• Confusing arrays with nested documents
• Thinking insertOne can't insert nested docs
• Forgetting commas between fields

5. You want to insert multiple user profiles with nested address documents using insertMany. Which command correctly inserts two users with nested addresses?

hard

A. db.users.insertMany([{name: "Anna", address: [city: "LA", zip: 90001]}, {name: "Mark", address: [city: "SF", zip: 94105]}])

B. db.users.insertMany({name: "Anna", address: {city: "LA", zip: 90001}}, {name: "Mark", address: {city: "SF", zip: 94105}})

C. db.users.insertMany([{name: "Anna", address: "city: LA, zip: 90001"}, {name: "Mark", address: "city: SF, zip: 94105"}])

D. db.users.insertMany([{name: "Anna", address: {city: "LA", zip: 90001}}, {name: "Mark", address: {city: "SF", zip: 94105}}])

Solution

1. Step 1: Verify insertMany syntax with array of documents

   insertMany requires an array of document objects, each with nested documents using curly braces.

2. Step 2: Check nested document syntax inside each user

   Nested 'address' fields must be objects with curly braces, not arrays or strings.

3. Final Answer:

   db.users.insertMany([{name: "Anna", address: {city: "LA", zip: 90001}}, {name: "Mark", address: {city: "SF", zip: 94105}}]) -> Option D

4. Quick Check:

   insertMany + array + nested docs with { } = db.users.insertMany([{name: "Anna", address: {city: "LA", zip: 90001}}, {name: "Mark", address: {city: "SF", zip: 94105}}]) [OK]

Hint: Use array of objects with nested docs in insertMany [OK]

Common Mistakes:

• Passing multiple documents as separate arguments instead of array
• Using arrays instead of objects for nested documents
• Putting nested data as strings instead of objects