Database Normalization Flashcards

Flashcards on Database Normalization

Normalization

Organizing data by separating it into multiple tables to reduce data duplication and increase data integrity.

Normalization

Helps to reduce duplication of data within the table itself.

Normalization

Customer information is stored in a single customer table, and that customer moves, we only have to change the ID, and it would be reflected appropriately in all of the other places in that table.

First Normal Form (1NF)

Ensures that the table contains no repeating groups or columns within the table itself.

Second Normal Form

All attributes in the table must depend on the primary key, ensuring data in different columns is related.

Third Normal Form

There should be no attributes in a table that do not depend on the primary key.

Normalization

Table contains no repeating groups and all attributes depend on the primary key.

Normalization

Applied to database by removing duplication within data tables and splitting data across multiple tables.