Normalization Basics for Grade 11

Front

Normalization

Back

Process of organizing data

Front

First Normal Form (1NF)

Back

Eliminate duplicate columns

Front

Second Normal Form (2NF)

Back

Remove subsets of data

Front

Third Normal Form (3NF)

Back

Remove transitive dependencies

Front

Partial Dependency

Back

Depends on part of primary key

Front

Transitive Dependency

Back

Depends on non-key attribute

Front

Primary Key

Back

Unique identifier for records

Front

Composite Key

Back

Multiple attributes as key

Front

Atomic Value

Back

Indivisible value

Front

Data Redundancy

Back

Duplicate data storage