Functional dependency definition in DBMS Theory - Mini Project: Build & Apply

Understanding Functional Dependency Definition

📖 Scenario: You are learning about database design. Functional dependency is a key concept that helps organize data efficiently. Imagine you have a table of students with their ID, name, and email. Knowing how one piece of data depends on another helps keep the database clean and avoid mistakes.

🎯 Goal: Build a clear definition of functional dependency using simple examples. You will create a data structure to represent attributes, set a dependency rule, explain the core logic of dependency, and finalize the definition.

📋 What You'll Learn

Create a dictionary called attributes with keys 'StudentID', 'Name', and 'Email' and example values

Add a variable called dependency_rule that shows 'StudentID' determines 'Name' and 'Email'

Write a function called is_functionally_dependent that takes two attribute names and returns true if the first determines the second based on the rule

Add a final statement that uses the function to check if 'StudentID' determines 'Email'

💡 Why This Matters

🌍 Real World

Functional dependency helps database designers organize data to avoid duplication and maintain consistency.

💼 Career

Understanding functional dependencies is essential for roles like database administrator, data analyst, and software developer working with relational databases.

1

Create the initial attributes dictionary

Create a dictionary called attributes with these exact entries: 'StudentID': 101, 'Name': 'Alice', and 'Email': '[e-mail]'.

DBMS Theory

# Create the attributes dictionary with StudentID, Name, and Email
# Your code here

Need a hint?

Use curly braces to create a dictionary and separate keys and values with colons.

2

Add the functional dependency rule

Add a variable called dependency_rule that is a dictionary with the key 'StudentID' and the value as a list containing 'Name' and 'Email'.

DBMS Theory

attributes = {'StudentID': 101, 'Name': 'Alice', 'Email': '[e-mail]'}
# Add the dependency_rule dictionary
# Your code here

Need a hint?

The dependency rule shows which attributes depend on 'StudentID'. Use a list for multiple dependent attributes.

3

Write the function to check functional dependency

Write a function called is_functionally_dependent that takes two parameters: determinant and dependent. The function should return True if dependent is in the list of attributes determined by determinant in dependency_rule, otherwise False.

DBMS Theory

attributes = {'StudentID': 101, 'Name': 'Alice', 'Email': '[e-mail]'}
dependency_rule = {'StudentID': ['Name', 'Email']}
# Define the function is_functionally_dependent
# Your code here

Need a hint?

Use the get method on the dictionary to avoid errors if the determinant is not found.

4

Check if StudentID determines Email

Add a variable called result that stores the result of calling is_functionally_dependent with 'StudentID' as the determinant and 'Email' as the dependent attribute.

DBMS Theory

attributes = {'StudentID': 101, 'Name': 'Alice', 'Email': '[e-mail]'}
dependency_rule = {'StudentID': ['Name', 'Email']}

def is_functionally_dependent(determinant, dependent):
    return dependent in dependency_rule.get(determinant, [])

# Store the check result in variable result
# Your code here

Need a hint?

Call the function with the exact strings 'StudentID' and 'Email' and assign it to result.