NoSQL database types (document, key-value, column, graph) in DBMS Theory - Mini Project: Build & Apply

Explore NoSQL Database Types with Sample Data

📖 Scenario: You are working as a junior database assistant in a company that wants to understand different NoSQL database types. They want you to create simple examples of data stored in four common NoSQL types: document, key-value, column, and graph databases.This will help the team see how data looks and is organized differently in each type.

🎯 Goal: Create small sample data structures for each NoSQL database type: document, key-value, column, and graph. You will build each step by adding data or configuration to represent these types clearly.

📋 What You'll Learn

Create a document database example with a collection of user profiles

Create a key-value store example with product prices

Create a column store example with sales data organized by region and month

Create a graph database example with nodes representing people and edges representing friendships

💡 Why This Matters

🌍 Real World

Understanding how different NoSQL databases store and organize data helps in choosing the right database type for specific applications like user profiles, product catalogs, sales analytics, or social networks.

💼 Career

Many jobs in data engineering, backend development, and database administration require knowledge of NoSQL database types and how to model data effectively for each.

1

Create a document database example

Create a variable called document_db that holds a list of dictionaries. Each dictionary represents a user profile with these exact keys and values: {'id': 1, 'name': 'Alice', 'age': 30}, {'id': 2, 'name': 'Bob', 'age': 25}, and {'id': 3, 'name': 'Charlie', 'age': 35}.

DBMS Theory

# Create a variable called document_db with three user profile dictionaries
# Your code here

Need a hint?

Use a list with three dictionaries inside. Each dictionary has keys 'id', 'name', and 'age' with the exact values given.

2

Create a key-value store example

Create a variable called key_value_store that is a dictionary with these exact key-value pairs: 'apple': 0.5, 'banana': 0.3, and 'cherry': 0.2 representing product prices.

DBMS Theory

document_db = [
    {'id': 1, 'name': 'Alice', 'age': 30},
    {'id': 2, 'name': 'Bob', 'age': 25},
    {'id': 3, 'name': 'Charlie', 'age': 35}
]
# Create a dictionary called key_value_store with product prices
# Your code here

Need a hint?

Use a dictionary with the exact keys and prices given.

3

Create a column store example

Create a variable called column_store that is a dictionary with keys as region names 'North' and 'South'. Each key maps to another dictionary with months as keys 'Jan' and 'Feb' and sales numbers as values. Use these exact values: North: Jan=100, Feb=150; South: Jan=200, Feb=250.

DBMS Theory

document_db = [
    {'id': 1, 'name': 'Alice', 'age': 30},
    {'id': 2, 'name': 'Bob', 'age': 25},
    {'id': 3, 'name': 'Charlie', 'age': 35}
]

key_value_store = {
    'apple': 0.5,
    'banana': 0.3,
    'cherry': 0.2
}
# Create a dictionary called column_store with sales data by region and month
# Your code here

Need a hint?

Use a dictionary with region keys and nested dictionaries for months and sales.

4

Create a graph database example

Create a variable called graph_db that is a dictionary with two keys: 'nodes' and 'edges'. 'nodes' is a list of dictionaries representing people with 'id' and 'name': {'id': 1, 'name': 'Alice'}, {'id': 2, 'name': 'Bob'}, {'id': 3, 'name': 'Charlie'}. 'edges' is a list of dictionaries representing friendships with 'from' and 'to' keys: {'from': 1, 'to': 2}, {'from': 2, 'to': 3}.

DBMS Theory

document_db = [
    {'id': 1, 'name': 'Alice', 'age': 30},
    {'id': 2, 'name': 'Bob', 'age': 25},
    {'id': 3, 'name': 'Charlie', 'age': 35}
]

key_value_store = {
    'apple': 0.5,
    'banana': 0.3,
    'cherry': 0.2
}

column_store = {
    'North': {'Jan': 100, 'Feb': 150},
    'South': {'Jan': 200, 'Feb': 250}
}
# Create a dictionary called graph_db with nodes and edges representing friendships
# Your code here

Need a hint?

Use a dictionary with 'nodes' and 'edges' keys. 'nodes' is a list of people dictionaries, 'edges' is a list of friendship dictionaries.