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

Understanding Many-to-Many Relationships

📖 Scenario: You are organizing a community event where people can join multiple clubs, and each club can have multiple members. You want to keep track of which people belong to which clubs.

🎯 Goal: Create a simple data structure that shows the many-to-many relationship between people and clubs.

📋 What You'll Learn

Create a list of people with exact names

Create a list of clubs with exact names

Create a dictionary that links each person to the clubs they belong to

Create a dictionary that links each club to the people who are members

💡 Why This Matters

🌍 Real World

Many-to-many relationships appear in social networks, school courses, event planning, and more where multiple entities connect in complex ways.

💼 Career

Understanding these relationships is important for database design, software development, and data organization in many jobs.

1

Create the list of people

Create a list called people with these exact names: 'Alice', 'Bob', and 'Charlie'.

No-Code

# Create the list of people
# Your code here

Need a hint?

Use square brackets to create a list and put the names inside quotes separated by commas.

2

Create the list of clubs

Create a list called clubs with these exact names: 'Chess', 'Book', and 'Cooking'.

No-Code

people = ['Alice', 'Bob', 'Charlie']
# Create the list of clubs
# Your code here

Need a hint?

Use a list like in step 1 but with the club names.

3

Link people to their clubs

Create a dictionary called person_to_clubs that links each person to the clubs they belong to with these exact entries: 'Alice' belongs to 'Chess' and 'Book', 'Bob' belongs to 'Book' and 'Cooking', and 'Charlie' belongs to 'Chess'.

No-Code

people = ['Alice', 'Bob', 'Charlie']
clubs = ['Chess', 'Book', 'Cooking']
# Create the dictionary person_to_clubs
# Your code here

Need a hint?

Use curly braces to create a dictionary. Each key is a person, and the value is a list of clubs.

4

Link clubs to their members

Create a dictionary called club_to_people that links each club to the people who are members with these exact entries: 'Chess' has 'Alice' and 'Charlie', 'Book' has 'Alice' and 'Bob', and 'Cooking' has 'Bob'.

No-Code

people = ['Alice', 'Bob', 'Charlie']
clubs = ['Chess', 'Book', 'Cooking']
person_to_clubs = {
    'Alice': ['Chess', 'Book'],
    'Bob': ['Book', 'Cooking'],
    'Charlie': ['Chess']
}
# Create the dictionary club_to_people
# Your code here

Need a hint?

Use a dictionary where each key is a club and the value is a list of people.