Last updated: Jan 24, 2022

Normalization

Normalization is the process of removal of data redundancy from a relation or set of relations which may cause insertion, deletion, and update anomalies.

Need for Normalization

This article will discuss the need for normalization in databases. We shall analyze the reason and also see various types of normal forms.

Author Ankit Kumar

1 upvote

The Problem of Redundancy EASY

In this article, we will discuss the anomalies associated with data redundancy using various examples.

1 upvote

2NF-Second Normal Form

This article explains the Second Normal Form (2NF) in database normalization using examples.

Author Reet Maggo

2 upvotes

Normalization in DBMS EASY

The article will discuss the normalization in the dbms and how it helps to minimize the redundant data by decomposing the tables.

Author Harshita Rajput

2 upvotes

3NF-Third Normal Form

This article covers the Third Normal Form (3NF) in database normalization using several examples.

Author Reet Maggo

2 upvotes

Boyce-Codd Normal Form

This article will discuss and explain the Boyce Codd Normal Form (BCNF) in database normalization using examples.

1 upvote

BCNF in DBMS EASY

This article will discuss and explain the Boyce Codd Normal Form (BCNF) in database normalization using examples.

0 upvotes

Fourth Normal Form

This article will discuss the fourth normal form used in database normalization. We shall also see an example of the same.

Author Ankit Kumar

2 upvotes

Fifth Normal Form

In this post, we will learn what the Fifth Normal Form is and how it is achieved. We will also discuss Prerequisites and examples of the Fifth Normal Form.

Author Sanjana Yadav

1 upvote

Highest Normal Form of a Relation

In this article, we will learn how to find the highest normal form of a given relation.

Author Reet Maggo

1 upvote

Difference Between 3NF and BCNF EASY

Normalization makes the data in our database non-redundant. In this article, we will learn the difference between 3NF and BCNF normal forms.

Author Rohit Kumar

1 upvote

Domain Key Normal Form EASY

This article will cover detailed analysis about domain key normal form(DKNF). We will see how to make a relation into DKNF.

Author Ankit Kumar

0 upvotes

Data Replication

In this post, we will cover the concept of Data Replication. We will learn about Data Replication, its types, advantages, and disadvantages.

Author Sanjana Yadav

1 upvote

Denormalization in Databases

This article will discuss denormalization in databases.

Author Gaurish Anand

1 upvote