First Move (11~18) - Code, Learn, Build
🧭 Career CompassDashboardProgress
Loading...
First Move (11~18) - Code, Learn, Build

Structured, level-based technology learning paths from foundational exploration to industry mastery.

Learning Domains

  • Python Programming (Active)
  • Computer Science Core
  • Web Development
  • AI & Machine Learning

Platform Architecture

  • Level-Based Progression
  • Decoupled Content Schema
  • Modular Code Execution Engine
  • Curated Official Resources

© 2026 First Move (11~18) • CODE • LEARN • BUILD. Built with Next.js App Router.

Readability & Accessibility First

← SQL & Database Management Systems|Level 2: Subqueries, Normalization & ACID Transactions

3. Database Normalization (1NF, 2NF, 3NF) & ER Diagrams

Lesson 3 of 6
Saved Locally (Guest)
Progress
0%

Database Normalization (1NF, 2NF, 3NF) & ER Diagrams

Eliminate update anomalies, duplicate data redundancy, and functional dependency violations through 1NF, 2NF, and 3NF normalization.

Normal Forms Overview

### Database Normalization Stages - **First Normal Form (1NF)**: Atomic values per cell (no multi-value comma arrays). - **Second Normal Form (2NF)**: Satisfies 1NF and removes Partial Key Dependencies. - **Third Normal Form (3NF)**: Satisfies 2NF and removes Transitive Dependencies (non-key attribute determining another non-key attribute).
💻 Ready to test your knowledge with code?
Solve the hands-on coding exercise in the interactive code editor.