User feedback collection in No-Code - Mini Project: Build & Apply

User Feedback Collection Database

📖 Scenario: You are building a simple database to collect user feedback for a website. This database will store user names, their email addresses, and their feedback messages.

🎯 Goal: Create a database table to store user feedback with fields for user name, email, and feedback message. Then, configure a status field to track if feedback is reviewed. Finally, write a query to select all unreviewed feedback and mark them as reviewed.

📋 What You'll Learn

Create a table called feedback with columns username (text), email (text), and message (text).

Add a column status (text) to track if feedback is 'new' or 'reviewed'.

Write a query to select all feedback where status is 'new'.

Write a query to update the status of selected feedback to 'reviewed'.

💡 Why This Matters

🌍 Real World

Collecting and managing user feedback is essential for improving websites and services. This project simulates a simple feedback database.

💼 Career

Database skills like creating tables and writing queries are fundamental for roles in data management, customer support systems, and web development.

1

Create the feedback table

Create a table called feedback with columns username as text, email as text, and message as text.

No-Code

-- Your code here to create the feedback table

Need a hint?

Use CREATE TABLE statement with the exact column names and types.

2

Add a status column

Add a column called status of type text to the feedback table to track if feedback is 'new' or 'reviewed'.

No-Code

CREATE TABLE feedback (
    username TEXT,
    email TEXT,
    message TEXT
);
-- Your code here to add status column

Need a hint?

Add the status column inside the CREATE TABLE statement.

3

Select unreviewed feedback

Write a SQL query to select all columns from the feedback table where the status is 'new'.

No-Code

CREATE TABLE feedback (
    username TEXT,
    email TEXT,
    message TEXT,
    status TEXT
);

-- Your code here to select unreviewed feedback

Need a hint?

Use SELECT * FROM feedback WHERE status = 'new' to get unreviewed feedback.

4

Mark feedback as reviewed

Write a SQL query to update the status to 'reviewed' for all feedback entries where the status is currently 'new'.

No-Code

CREATE TABLE feedback (
    username TEXT,
    email TEXT,
    message TEXT,
    status TEXT
);

SELECT * FROM feedback WHERE status = 'new';

-- Your code here to update status to reviewed

Need a hint?

Use UPDATE feedback SET status = 'reviewed' WHERE status = 'new' to mark feedback as reviewed.