Data types and database setup in No-Code - Mini Project: Build & Apply

Data types and database setup

📖 Scenario: You are helping a small business owner organize their customer information in a simple database. The business owner wants to store names, ages, email addresses, and whether the customer is a member of their loyalty program.

🎯 Goal: Create a basic database setup by defining the correct data types for each piece of customer information. This will help the business owner keep their data organized and easy to use.

📋 What You'll Learn

Define a data structure to hold customer information with fields: Name, Age, Email, and Loyalty Member status

Assign appropriate data types to each field: text for names and emails, number for age, and boolean for loyalty membership

Set up a simple table or list format to represent the database

Ensure the data types match the kind of information stored for easy sorting and searching

💡 Why This Matters

🌍 Real World

Organizing customer data with correct data types helps businesses manage information efficiently and avoid errors.

💼 Career

Understanding data types and database setup is essential for roles in data entry, database administration, and software development.

1

Create the customer data structure

Create a data structure called customer with these exact fields and example values: Name as "Alice", Age as 30, Email as "[e-mail]", and LoyaltyMember as true.

No-Code

# Define the customer data structure with the specified fields and values
# Your code here

Need a hint?

Use a dictionary or similar structure with keys for each field and assign the exact values given.

2

Add a data type reference

Create a dictionary called data_types that maps each field name to its correct data type as a string: Name and Email to "text", Age to "number", and LoyaltyMember to "boolean".

No-Code

customer = {
    "Name": "Alice",
    "Age": 30,
    "Email": "[e-mail]",
    "LoyaltyMember": True
}

# Create the data_types dictionary mapping fields to their data types
# Your code here

Need a hint?

Use a dictionary with field names as keys and data type names as string values.

3

Create a list to hold multiple customers

Create a list called customers that contains two customer dictionaries. The first is the existing customer dictionary. The second is a new dictionary with Name "Bob", Age 25, Email "[e-mail]", and LoyaltyMember false.

No-Code

customer = {
    "Name": "Alice",
    "Age": 30,
    "Email": "[e-mail]",
    "LoyaltyMember": True
}

data_types = {
    "Name": "text",
    "Age": "number",
    "Email": "text",
    "LoyaltyMember": "boolean"
}

# Create the customers list with the existing customer and a new customer dictionary
# Your code here

Need a hint?

Use a list containing the existing customer and a new dictionary with Bob's details.

4

Add a field for phone number with correct data type

Add a new field called PhoneNumber with the value "[phone]" to both customer dictionaries inside the customers list. Also add "PhoneNumber": "text" to the data_types dictionary.

No-Code

customer = {
    "Name": "Alice",
    "Age": 30,
    "Email": "[e-mail]",
    "LoyaltyMember": True
}

data_types = {
    "Name": "text",
    "Age": "number",
    "Email": "text",
    "LoyaltyMember": "boolean"
}

customers = [
    customer,
    {
        "Name": "Bob",
        "Age": 25,
        "Email": "[e-mail]",
        "LoyaltyMember": False
    }
]

# Add PhoneNumber field with value "[phone]" to both customers
# Add "PhoneNumber": "text" to data_types
# Your code here

Need a hint?

Add the new field and data type exactly as shown to both customer dictionaries and the data_types dictionary.