Course/Module 7/Topic 3 of 3Intermediate

Database Design & Normalization - Practice

Put your database design & normalization skills to the test with practical exercises and challenges.

50 min•By Priygop Team•Last updated: Feb 2026

Hands-On Practice

Practice makes perfect! In this section, you'll work through practical exercises that reinforce the concepts covered in this module.

Exercises

Exercise 1: Apply basic database design & normalization concepts
Exercise 2: Solve intermediate-level challenges
Exercise 3: Build a mini-project using database design & normalization
Exercise 4: Debug and fix common issues

Practice: Database Design & Normalization

Practice: Database Design & NormalizationJavaScript⚠ 1 error

⚠ Syntax Issues (1)

Line 1: JS Error: Unexpected identifier 'a'

💡 Check syntax near the highlighted line.

JavaScript Editor

✕ 1 errorTab = 2 spaces

-- Design a simple schema
CREATE TABLE categories (
  id SERIAL PRIMARY KEY,
  name VARCHAR(100) NOT NULL UNIQUE
);

CREATE TABLE products (
  id SERIAL PRIMARY KEY,
  name VARCHAR(200) NOT NULL,
  price DECIMAL(10,2) NOT NULL CHECK (price > 0),
  category_id INTEGER REFERENCES categories(id),
  created_at TIMESTAMP DEFAULT NOW()
);

-- Add an index
CREATE INDEX idx_products_category ON products(category_id);

Result

Click ▶ Run to see the result

Edit the code on the left, then click Run

JavaScript|16 lines|412 chars|1 error, 0 warnings

UTF-8

Review Quiz

Next Module →

Chat on WhatsAppPriygop - Leading Professional Development Platform | Expert Courses & Interview Prep