Normalization of DBMS

Flashcards covering key concepts related to normalization in Database Management Systems.

Normalization

The process of minimizing redundancy from a relation or set of relations in a database.

Redundancy

Unnecessary duplication of data in a database that may cause anomalies.

First Normal Form (1NF)

A condition of a relation where it does not contain any composite or multi-valued attributes.

Second Normal Form (2NF)

A form of database normalization that requires the removal of partial dependencies.

Third Normal Form (3NF)

A level of normalization where no transitive dependencies exist.

Insertion Anomaly

An issue that occurs when certain attributes cannot be inserted into a database without the presence of other attributes.

Deletion Anomaly

A problem that arises when the deletion of data inadvertently removes other relevant data.

Update Anomaly

An issue where changes in data require multiple updates to maintain consistency.

Composite Primary Key

A primary key made up of two or more attributes that uniquely identify a record.

Single Valued Attribute

An attribute that can hold only one value for a particular entity.