What is a database management system in DBMS Theory - Hands-On Activity

What is a database management system

📖 Scenario: Imagine you have a large collection of books at home. You want to keep track of each book's title, author, and year of publication. Instead of writing everything on paper, you decide to organize this information on your computer so you can find any book quickly.

🎯 Goal: You will create a simple example that shows how a database management system (DBMS) helps organize and manage data like your book collection.

📋 What You'll Learn

Create a list of books with title, author, and year

Add a variable to count how many books are in the list

Use a loop to go through each book and collect titles

Add a final statement that explains what a DBMS does

💡 Why This Matters

🌍 Real World

Organizing and managing data like books, customers, or products is common in many areas such as libraries, stores, and websites.

💼 Career

Understanding what a DBMS is helps in jobs related to data management, software development, and IT support.

1

DATA SETUP: Create a list of books

Create a list called books with these three dictionaries exactly: {'title': 'The Hobbit', 'author': 'J.R.R. Tolkien', 'year': 1937}, {'title': '1984', 'author': 'George Orwell', 'year': 1949}, and {'title': 'To Kill a Mockingbird', 'author': 'Harper Lee', 'year': 1960}.

DBMS Theory

# Create the list called books with the three dictionaries
# Your code here

Need a hint?

Use a list with three dictionaries. Each dictionary should have keys 'title', 'author', and 'year' with the exact values given.

2

CONFIGURATION: Count the number of books

Create a variable called book_count and set it to the number of items in the books list using the len() function.

DBMS Theory

books = [
    {'title': 'The Hobbit', 'author': 'J.R.R. Tolkien', 'year': 1937},
    {'title': '1984', 'author': 'George Orwell', 'year': 1949},
    {'title': 'To Kill a Mockingbird', 'author': 'Harper Lee', 'year': 1960}
]
# Create book_count to hold the number of books
# Your code here

Need a hint?

Use the len() function to find how many books are in the list.

3

CORE LOGIC: Collect all book titles

Create an empty list called titles. Use a for loop with the variable book to go through each item in books. Inside the loop, add the title from each book to the titles list using the append() method.

DBMS Theory

books = [
    {'title': 'The Hobbit', 'author': 'J.R.R. Tolkien', 'year': 1937},
    {'title': '1984', 'author': 'George Orwell', 'year': 1949},
    {'title': 'To Kill a Mockingbird', 'author': 'Harper Lee', 'year': 1960}
]
book_count = len(books)

# Create titles list and add each book's title using a for loop
# Your code here

Need a hint?

Start with an empty list. Use a for loop to go through each book and add the title to the list.

4

COMPLETION: Add a description of a DBMS

Create a string variable called dbms_description and set it to this exact text: 'A database management system (DBMS) is software that helps store, organize, and manage data efficiently.'

DBMS Theory

books = [
    {'title': 'The Hobbit', 'author': 'J.R.R. Tolkien', 'year': 1937},
    {'title': '1984', 'author': 'George Orwell', 'year': 1949},
    {'title': 'To Kill a Mockingbird', 'author': 'Harper Lee', 'year': 1960}
]
book_count = len(books)

titles = []
for book in books:
    titles.append(book['title'])

# Add the dbms_description string variable below
# Your code here

Need a hint?

Assign the exact text to the variable dbms_description.