Author: <span class="vcard">Anupreet Kalsi</span>

In a database, decomposition refers to the breaking down of a relation into multiple smaller relations. Relational Decomposition is done when a relation in the database is not in an…

DBMS

Before going into depth about what the Fifth Normal Form while normalizing databases is, we should have knowledge about a type of dependency known as Join Dependency. What actually a…

DBMS

Once we have normalized relation to Third Normal Form or BCNF, it is still possible that at certain times anomalies like Insert, Update or Delete may still arise. This usually…

DBMS

Before going into the details about Fourth Normal Form (4NF), we must understand what multivalued dependency really is. What is meant by Multivalued Dependency? Multivalued dependency is the type of…

Uncategorized

DBMS

A normal form which is stricter than other normal forms is the Third Normal Form (3NF). Third normal form tries to eliminate most of the redundant data hence reducing redundancy…

DBMS

The Second Normal Form (2NF) is used to establish a relation between the key (simple or composite) attributes and all the non-key attributes of the table. It is in the…

DBMS

A relation is said to be in a particular normal form when it follows certain set of rules. So is the case with 1NF. A data table is said to…

DBMS

Inference rule is a type of assertion which is applied in DBMS to derive new functional dependencies from already existing functional dependencies. William Armstrong developed these axioms in 1974. Hence…

DBMS

Functional Dependency (FD) is a DBMS Concept which arises due to the inter dependency between the attributes (columns) of a relation (table). As a result, Functional Dependency forms the basis…

DBMS