Denormalization Strategies: When and how to selectively denormalize for performance

Constraints & Integrity: Enforce referential integrity in normalized schema

Indexing Strategies: Index foreign keys for fast joins in normalized tables

Materialized Views: Pre-compute expensive joins for read-heavy workloads

Database Design Patterns: Common patterns for normalized schemas

Query Optimization: Optimize joins in normalized schema

Partitioning: Partition large normalized tables for performance

Normalize unnormalized table to 1NF (eliminate repeating groups)

Identify partial dependencies and convert to 2NF

Identify transitive dependencies and convert to 3NF

Check BCNF violations and fix (every determinant is candidate key)

Design normalized schema for e-commerce system (products, orders, customers)

Design normalized schema for social media (users, posts, comments, likes)

Identify functional dependencies in given schema

Compare normalized vs unnormalized performance (measure query times)

Explain 1NF, 2NF, 3NF, BCNF with examples

What are functional dependencies? How to identify them?

What is the difference between partial and transitive dependencies?

When should you denormalize? What are the trade-offs?

Design normalized schema for library system (books, authors, members, loans)

Identify normalization violations in given schema and fix

How does normalization affect query performance?

What is BCNF? How is it different from 3NF?

Database Normalization Guide: https://en.wikipedia.org/wiki/Database_normalization

Functional Dependencies: https://en.wikipedia.org/wiki/Functional_dependency

Normal Forms Explained: https://www.guru99.com/database-normalization.html

BCNF vs 3NF: https://www.geeksforgeeks.org/boyce-codd-normal-form-bcnf/

Database Design Best Practices: https://www.postgresql.org/docs/current/ddl.html