Election process concept in MongoDB - Mini Project: Build & Apply

Election Process Concept in MongoDB

📖 Scenario: You are helping organize a small community election. You want to store information about candidates and votes in a MongoDB database.This project will guide you to create a collection for candidates, add a configuration for minimum votes to win, count votes for each candidate, and finally determine the winner.

🎯 Goal: Build a MongoDB setup that stores candidates, counts votes, and identifies the winner based on a minimum vote threshold.

📋 What You'll Learn

Create a candidates collection with candidate names and their initial votes.

Add a configuration variable min_votes_to_win to set the minimum votes needed to win.

Write a query to count votes for each candidate.

Write a query to find the candidate(s) who meet or exceed the minimum votes to win.

💡 Why This Matters

🌍 Real World

Community groups and organizations often use databases like MongoDB to manage election data efficiently.

💼 Career

Understanding how to store and query election data is useful for roles in data management, civic tech, and backend development.

1

Create the candidates collection with initial data

Create a MongoDB collection called candidates and insert these exact documents: { name: "Alice", votes: 10 }, { name: "Bob", votes: 15 }, and { name: "Charlie", votes: 7 }.

MongoDB

// Insert the candidates documents into the candidates collection
// Your code here

Hint

Use insertMany to add multiple documents to the candidates collection.

2

Add a minimum votes to win configuration

Create a variable called min_votes_to_win and set it to 12 to represent the minimum votes a candidate needs to win.

MongoDB

db.candidates.insertMany([
  { name: "Alice", votes: 10 },
  { name: "Bob", votes: 15 },
  { name: "Charlie", votes: 7 }
])

// Create min_votes_to_win variable
// Your code here

Hint

Use const to declare the variable min_votes_to_win with the value 12.

3

Query to count votes for each candidate

Write a MongoDB query using find() on the candidates collection to get all candidates with their names and votes.

MongoDB

db.candidates.insertMany([
  { name: "Alice", votes: 10 },
  { name: "Bob", votes: 15 },
  { name: "Charlie", votes: 7 }
])

const min_votes_to_win = 12

// Query all candidates with their votes
// Your code here

Hint

Use find() with a projection to show only name and votes fields.

4

Find the winner(s) based on minimum votes

Write a MongoDB query using find() on the candidates collection to find candidate(s) where votes is greater than or equal to min_votes_to_win. Store the result in a variable called winners.

MongoDB

db.candidates.insertMany([
  { name: "Alice", votes: 10 },
  { name: "Bob", votes: 15 },
  { name: "Charlie", votes: 7 }
])

const min_votes_to_win = 12

const allCandidates = db.candidates.find({}, { name: 1, votes: 1, _id: 0 })

// Find candidates with votes >= min_votes_to_win
// Your code here

Hint

Use the $gte operator in the query filter to find candidates with votes greater than or equal to min_votes_to_win.

Practice

1. What is the main purpose of an election in a MongoDB replica set?

easy

A. To select a primary server that manages writes

B. To delete old data from the database

C. To backup the database automatically

D. To create new collections in the database

Solution

1. Step 1: Understand the role of election in MongoDB

   In a replica set, election chooses a primary server to handle write operations.

2. Step 2: Identify the correct purpose

   The primary server manages writes and coordinates data replication.

3. Final Answer:

   To select a primary server that manages writes -> Option A

4. Quick Check:

   Election = select primary server [OK]

Hint: Election picks the primary server for writes [OK]

Common Mistakes:

• Thinking election deletes data
• Confusing election with backup process
• Believing election creates collections

2. Which MongoDB command shows the current election status in a replica set?

easy

A. db.showElection()

B. db.electionStatus()

C. rs.status()

D. rs.election()

Solution

1. Step 1: Recall the command to check replica set status

   The command rs.status() shows detailed replica set info including election status.

2. Step 2: Verify other options

   Other commands like db.showElection() or rs.election() do not exist in MongoDB.

3. Final Answer:

   rs.status() -> Option C

4. Quick Check:

   Check election with rs.status() [OK]

Hint: Use rs.status() to see election info [OK]

Common Mistakes:

• Using non-existent commands
• Confusing db commands with rs commands
• Trying to use election-specific commands that don't exist

3. Given the following output from rs.status(), which member is currently the primary?

{
  "members": [
    {"_id": 0, "stateStr": "SECONDARY"},
    {"_id": 1, "stateStr": "PRIMARY"},
    {"_id": 2, "stateStr": "SECONDARY"}
  ]
}

medium

A. Member with _id 0

B. No primary elected yet

C. Member with _id 2

D. Member with _id 1

Solution

1. Step 1: Read the stateStr values for each member

   Member with _id 1 has stateStr "PRIMARY", others are "SECONDARY".

2. Step 2: Identify the primary member

   The member with stateStr "PRIMARY" is the current primary server.

3. Final Answer:

   Member with _id 1 -> Option D

4. Quick Check:

   Primary = stateStr "PRIMARY" member [OK]

Hint: Primary member has stateStr 'PRIMARY' in rs.status() [OK]

Common Mistakes:

• Choosing a secondary member
• Assuming no primary if unsure
• Ignoring the stateStr field

4. You run rs.status() but get an error: not authorized on admin to execute command. What is the likely cause?

medium

A. You lack proper user permissions to run rs.status()

B. You are not connected to the primary server

C. The replica set is not initialized

D. The command rs.status() is misspelled

Solution

1. Step 1: Understand the error message

   The error says 'not authorized', meaning permission is denied.

2. Step 2: Match error to cause

   Lack of user permissions to run the command causes this error, not connection or spelling issues.

3. Final Answer:

   You lack proper user permissions to run rs.status() -> Option A

4. Quick Check:

   Authorization error = permission issue [OK]

Hint: Authorization errors mean missing user permissions [OK]

Common Mistakes:

• Assuming connection problem
• Thinking replica set not initialized
• Blaming command spelling

5. In a MongoDB replica set with 5 members, what minimum number of votes is needed to elect a primary during an election?

hard

A. 2 votes

B. 3 votes

C. 4 votes

D. 5 votes

Solution

1. Step 1: Recall election voting rules in MongoDB

   Primary election requires a majority of votes from members.

2. Step 2: Calculate majority for 5 members

   Majority is more than half, so 3 out of 5 votes are needed.

3. Final Answer:

   3 votes -> Option B

4. Quick Check:

   Majority of 5 = 3 votes [OK]

Hint: Majority votes needed: half members + 1 [OK]

Common Mistakes:

• Choosing half votes instead of majority
• Thinking all members must vote
• Confusing votes with number of members