Normalization in Relational Databases

Flashcards about database normalization.

Normalization

Organizing data in a database following specific rules to create multiple tables and establish relationships between them.

Data Redundancy

The presence of the same data in multiple locations within a database, leading to wasted disc space and maintenance issues.

First Normal Form

A form of normalization that states a database should have no repeating groups in a table, a separate table for related data, and each set identified with a key.

Second Normal Form

A form of normalization where all attributes depend on the entire primary key.

Third Normal Form

A form of normalization that states you should eliminate fields in a table that do not depend on the key.