1NF,2NF,3NF & BCNF

Interactive Database Normalization

Master normalization through hands-on practice with real-time analysis and visual feedback

Interactive Normalization Lab

Design your own table and watch real-time normalization analysis as you work.

Design Your Table
StudentID StudentName Courses Instructors
101 John Smith Math, Physics Dr. Brown, Dr. Wilson
102 Sarah Johnson Chemistry, Biology Dr. Davis, Dr. Miller

Real-time Analysis

Modify the table above to see real-time normalization analysis.

Functional Dependencies Visualizer

Current Functional Dependencies:

Analyze your table to see functional dependencies

Practice Scenarios

Choose a scenario to practice normalization:

Normalization Quiz

Which normal form eliminates repeating groups?
  • A) First Normal Form (1NF)
  • B) Second Normal Form (2NF)
  • C) Third Normal Form (3NF)
  • D) Boyce-Codd Normal Form (BCNF)

Normalization Progress

0 Unnormalized Form
1 First Normal Form
2 Second Normal Form
3 Third Normal Form
B Boyce-Codd NF

Normal Forms Quick Guide

• No repeating groups
• Each cell contains one value
• Unique rows
• Must be in 1NF
• No partial dependencies
• All attributes depend on full primary key
• Must be in 2NF
• No transitive dependencies
• Non-key attributes depend only on primary key

Table Statistics

4
Columns
2
Rows
3
Violations
UNF
Current NF

Quick Actions

Related Topics

Database Design Functional Dependencies ER Diagrams