In this tutorial, we will discuss Relational Algebra. In the previous tutorial, we had a brief discussion on the basics of relational algebra and calculus… [Read More]

In this guide, we will discuss what is Relational algebra and relational calculus and why we use these concepts. In the previous tutorials, we discussed… [Read More]

In the last tutorial, we learned Conflict Serializability. In this article, we will discuss another type of serializability which is known as View Serializability. What… [Read More]

In the DBMS Schedules guide, we learned that there are two types of schedules – Serial & Non-Serial. A Serial schedule doesn’t support concurrent execution… [Read More]

When multiple transactions are running concurrently then there is a possibility that the database may be left in an inconsistent state. Serializability is a concept… [Read More]

We know that transactions are set of instructions and these instructions perform operations on database. When multiple transactions are running concurrently then there needs to… [Read More]

In this guide, we will discuss the states of a transaction in DBMS. A transaction in DBMS can be in one of the following states…. [Read More]

Aggregation is a process in which a single entity alone is not able to make sense in a relationship so the relationship of two entities… [Read More]

Specialization is a process in which an entity is divided into sub-entities. You can think of it as a reverse process of generalization, in generalization… [Read More]

Generalization is a process in which the common attributes of more than one entities form a new entity. This newly formed entity is called generalized… [Read More]