Why transactions ensure data consistency in DBMS Theory - See It in Action

Why Transactions Ensure Data Consistency

📖 Scenario: Imagine a bank system where multiple people are sending money to each other at the same time. We want to make sure that the money is always correct and no one loses or gains money by mistake.

🎯 Goal: Build a simple example that shows how transactions help keep data consistent when multiple changes happen together.

📋 What You'll Learn

Create a dictionary called accounts with these exact entries: 'Alice': 1000, 'Bob': 500

Create a variable called transaction_active and set it to False

Write a function called transfer that takes sender, receiver, and amount and updates accounts only if transaction_active is True

Set transaction_active to True before calling transfer and set it back to False after

💡 Why This Matters

🌍 Real World

Banks and many other systems use transactions to keep data accurate when many changes happen at once.

💼 Career

Understanding transactions is important for database administrators, software developers, and anyone working with data systems to ensure data integrity.

1

Create the initial accounts data

Create a dictionary called accounts with these exact entries: 'Alice': 1000 and 'Bob': 500

DBMS Theory

# Create the accounts dictionary with Alice and Bob
# Your code here

Need a hint?

Use curly braces to create a dictionary with keys 'Alice' and 'Bob' and their balances.

2

Add a transaction status variable

Create a variable called transaction_active and set it to False

DBMS Theory

accounts = {'Alice': 1000, 'Bob': 500}
# Create transaction_active variable and set it to False
# Your code here

Need a hint?

This variable will help us know if a transaction is happening.

3

Write the transfer function with transaction check

Write a function called transfer that takes sender, receiver, and amount. Inside the function, check if transaction_active is True. If yes, subtract amount from accounts[sender] and add it to accounts[receiver]

DBMS Theory

accounts = {'Alice': 1000, 'Bob': 500}
transaction_active = False

def transfer(sender, receiver, amount):
    # Check if transaction_active is True
    # If yes, update accounts balances
    # Your code here

Need a hint?

Use an if statement to check transaction_active before changing balances.

4

Use transaction_active to control the transfer

Set transaction_active to True before calling transfer('Alice', 'Bob', 200) and set it back to False after

DBMS Theory

accounts = {'Alice': 1000, 'Bob': 500}
transaction_active = False

def transfer(sender, receiver, amount):
    global transaction_active
    if transaction_active:
        accounts[sender] -= amount
        accounts[receiver] += amount

# Set transaction_active True, call transfer, then set False
# Your code here

Need a hint?

This shows how transactions control when data changes happen.