One-to-many relationships in No-Code - Mini Project: Build & Apply

Understanding One-to-Many Relationships

📖 Scenario: You are organizing a small library system where each author can write multiple books. You want to represent this relationship clearly.

🎯 Goal: Build a simple representation of authors and their books to understand the one-to-many relationship concept.

📋 What You'll Learn

Create a data structure to hold authors and their books

Add a helper variable to count total books

Use a loop to list all books for each author

Complete the structure by adding a summary of total books

💡 Why This Matters

🌍 Real World

One-to-many relationships are common in databases and data organization, such as authors to books, teachers to students, or categories to products.

💼 Career

Understanding these relationships helps in designing databases, managing data, and building software that handles complex information.

1

Create the authors and books data

Create a dictionary called authors_books with these exact entries: 'Alice': ['Wonderland', 'Through the Looking Glass'], 'Bob': ['Adventures in Coding'], and 'Clara': ['Gardening Basics', 'Advanced Gardening'].

No-Code

# Create the authors_books dictionary with the given authors and their books
# Your code here

Need a hint?

Use a dictionary where keys are author names and values are lists of book titles.

2

Add a total books counter

Add a variable called total_books and set it to 0 to count all books.

No-Code

authors_books = {
    'Alice': ['Wonderland', 'Through the Looking Glass'],
    'Bob': ['Adventures in Coding'],
    'Clara': ['Gardening Basics', 'Advanced Gardening']
}
# Create total_books variable and set it to 0
# Your code here

Need a hint?

This variable will help count all books from all authors.

3

Count all books using a loop

Use a for loop with variables author and books to iterate over authors_books.items(). Inside the loop, add the number of books for each author to total_books.

No-Code

authors_books = {
    'Alice': ['Wonderland', 'Through the Looking Glass'],
    'Bob': ['Adventures in Coding'],
    'Clara': ['Gardening Basics', 'Advanced Gardening']
}
total_books = 0
# Use a for loop to add the count of books for each author to total_books
# Your code here

Need a hint?

Use len(books) to get the number of books for each author.

4

Add a summary of total books

Add a variable called summary and set it to the string "Total books in library: " concatenated with the string version of total_books.

No-Code

authors_books = {
    'Alice': ['Wonderland', 'Through the Looking Glass'],
    'Bob': ['Adventures in Coding'],
    'Clara': ['Gardening Basics', 'Advanced Gardening']
}
total_books = 0
for author, books in authors_books.items():
    total_books += len(books)
# Create summary string showing total books
# Your code here

Need a hint?

Use string concatenation and str() to combine text and number.