Rules of Normalization

Flashcards covering the rules of normalization in relational databases, including data anomalies and normal forms.

Normalization

A practice of following a set of rules for designing database tables to minimize the risk of data anomalies.

Data Anomalies

Errors or inconsistencies in data.

Update Anomaly

Occurs when redundant data is only partially updated.

Insertion Anomaly

Results when you're not able to add data to the database due to the absence of other data.

Deletion Anomaly

When you unintentionally lose data because you've deleted other data.

First Normal Form

Each value in a column is an atomic unit.

Second Normal Form

Any attribute in a table is dependent on the key.

Third Normal Form

There are no transitive dependencies.

OLTP (Online Transaction Processing)

Systems with many reads and writes, constantly being updated.

Analytical Databases

Databases used for data analysis with many reads but fewer column inclusions in queries.