In this post, we will learn about dbms decomposition types and properties. We will go through different types – LossLess decomposition and dependency preserving, of decomposition in dbms with example. What is Decomposition ? Decomposition is the process of breaking …

Let us look at the concept of functional dependency in dbms with examples. Let R be a relational schema and let X and Y be non empty sets of attributes in R. We say that an instance‘r’ of R satisfies …

In this post, we will learn about normalization in dbms with examples. We will see different forms of normalization - 1 NF , 2 NF and 3 NF. Visit post to know more...

In this post, we will see different keys in rdbms with examples. They are  - primary key, Foreign key and Unique key. Visit post to know more...

In this post, we will see what are the different types of anomalies in DBMS. We will see anomalies in dbms caused to different operations - insertion, deletion, update etc. Visit post to know more...

In this post, we will see some additional relational algebra operations in dbms. These additional operations (set intersection, assignment, natural join operations, left outer join, right outer join and full outer join operation etc.) can be seen expressed using fundamental …

In this post, we will learn about DBMS relational data model concepts. We will go through different relational model terminologies - attribute, tuple, cardinality etc. Visit post to know more...