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
By Ankit Kumar
● Published At Jan 2022
This article will discuss the need for normalization in databases. We shall analyze the reason and also see various types of normal forms.... Keep reading ..
First Normal Form (1NF)
By Gaurish Anand
● Published At Jan 2022
This article will discuss the first normal form... Keep reading ..
The Problem of Redundancy
By Divyansh Jain
● Published At Feb 2022
In this article, we will discuss the anomalies associated with data redundancy using various examples. ... Keep reading ..
2NF-Second Normal Form
By Reet Maggo
● Published At Dec 2021
This article explains the Second Normal Form (2NF) in database normalization using examples.... Keep reading ..
3NF-Third Normal Form
By Reet Maggo
● Published At Jan 2022
This article covers the Third Normal Form (3NF) in database normalization using several examples.... Keep reading ..
Fourth Normal Form
By Ankit Kumar
● Published At Jan 2022
This article will discuss the fourth normal form used in database normalization. We shall also see an example of the same.... Keep reading ..
Fifth Normal Form
By Sanjana Yadav
● Published At Jan 2022
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. ... Keep reading ..
Highest Normal Form of a Relation
By Reet Maggo
● Published At Dec 2021
In this article, we will learn how to find the highest normal form of a given relation.... Keep reading ..
Domain Key Normal Form
By Ankit Kumar
● Published At Dec 2021
This article will cover detailed analysis about domain key normal form(DKNF). We will see how to make a relation into DKNF.... Keep reading ..
Data Replication
By Sanjana Yadav
● Published At Dec 2021
In this post, we will cover the concept of Data Replication. We will learn about Data Replication, its types, advantages, and disadvantages. ... Keep reading ..
Denormalization in Databases
By Gaurish Anand
● Published At Jan 2022
This article will discuss denormalization in databases. ... Keep reading ..
Example of Normalisation Conversions
By Ankit Kumar
● Published At Mar 2022
In this article, we will learn about Normalisation conversions and their examples. ... Keep reading ..