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
● Published At Dec 2021
This blog is about the Relational Decompositions, i.e., decomposition of a relation into multiple sub relations.... Keep reading ..