Database Design and Normalisation
Database Design involves defining how data needs to be stored in the database and how that data is interrelated. Normalization helps in making an optimal and more managed design for data storage.
Inference Rule in DBMS
By Saloni Singhal
● Published At Dec 2021
The objective of this blog is to understand what Inference rules are. ... Keep reading ..
Functional Dependencies
Functional dependency refers to the relationship between two attributes of a table. This relationship can be used to find the value of one attribute when that of the other is given. It can be mathematically represented as FD: X -> Y. Here, the values of Y are determined by the values of X. X and Y, being the attributes of the table.
Functional Dependencies and Attribute Closure
By Apoorv Dixit
● Published At Feb 2022
The article discusses functional dependencies followed by attribute closure and the method to find attribute closure.... Keep reading ..
Finding Attribute Closure and Candidate Keys
By Amisha Purswani
● Published At Dec 2021
In this blog, we will learn about attribute closure and candidate key and how to find attribute closure and candidate key with an example.... Keep reading ..
Armstrong Axioms
By Ankit Kumar
● Published At Jan 2022
The article talks about the Armstrong Axioms and the Secondary rules based on the axioms and their proofs.... Keep reading ..
Equivalence of Functional Dependencies
By Shivani Kumari
● Published At Jan 2022
In this article, we will describe the equivalence of two or more functional dependencies. Read the blog to learn more. ... Keep reading ..
Canonical Cover
By Ankit Kumar
● Published At Jan 2022
The article is about the Canonical cover and violation of the functional dependencies while updating the database. We will also see some examples of these concepts.... Keep reading ..
Relational Decomposition
By PRASHANT SINGH
● Published At Dec 2021
This blog is about the Relational Decompositions, i.e., decomposition of a relation into multiple sub relations.... Keep reading ..
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 ..
puzzle icon

Top Problems related to Database Design and Normalisation