BeginnersBook

  • Home
  • Java
    • Java OOPs
    • Java Collections
    • Java Examples
  • C
    • C Examples
  • C++
    • C++ Examples
  • DBMS
  • Computer Network
  • Python
    • Python Examples
  • More…
    • jQuery
    • Kotlin
    • WordPress
    • SEO
    • JSON
    • JSP
    • JSTL
    • Servlet
    • MongoDB
    • XML
    • Perl

DBMS Schedules and the Types of Schedules

By Chaitanya Singh | Filed Under: DBMS

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]

DBMS Transaction States

By Chaitanya Singh | Filed Under: DBMS

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]

DBMS Aggregration

By Chaitanya Singh | Filed Under: DBMS

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]

DBMS Specialization

By Chaitanya Singh | Filed Under: DBMS

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]

DBMS Generalization

By Chaitanya Singh | Filed Under: DBMS

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]

DBMS – Three Level Architecture

By Chaitanya Singh | Filed Under: DBMS

In the previous tutorial we have seen the DBMS architecture – one-tier, two-tier and three-tier. In this guide, we will discuss the three level DBMS… [Read More]

DBMS Architecture

By Chaitanya Singh | Filed Under: DBMS

In the previous tutorials, we learned basics of DBMS. In this guide, we will see the DBMS architecture. Database management systems architecture will help us… [Read More]

Concurrency Control in DBMS

By Chaitanya Singh | Filed Under: DBMS

When more than one transactions are running simultaneously there are chances of a conflict to occur which can leave database to an inconsistent state. To… [Read More]

Transaction Management in DBMS

By Chaitanya Singh | Filed Under: DBMS

A transaction is a set of logically related operations. For example, you are transferring money from your bank account to your friend’s account, the set… [Read More]

What is an attribute in DBMS? – Definition and explanation

By Chaitanya Singh | Filed Under: DBMS

You may hear this term often when dealing with Relational Database Management Systems (RDBMS). In RDBMS, a table organizes data in rows and columns. The… [Read More]

Normalization in DBMS: 1NF, 2NF, 3NF and BCNF in Database

By Chaitanya Singh | Filed Under: DBMS

Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly. Let’s discuss about anomalies… [Read More]

Deadlock in DBMS

By Chaitanya Singh | Filed Under: DBMS

A deadlock is a condition wherein two or more tasks are waiting for each other in order to be finished but none of the task… [Read More]

Constraints in DBMS

By Chaitanya Singh | Filed Under: DBMS

Constraints enforce limits to the data or type of data that can be inserted/updated/deleted from a table. The whole purpose of constraints is to maintain… [Read More]

Domain constraints in DBMS

By Chaitanya Singh | Filed Under: DBMS

A table is DBMS is a set of rows and columns that contain data. Columns in table have a unique name, often referred as attributes… [Read More]

Mapping constraints in DBMS

By Chaitanya Singh | Filed Under: DBMS

Mapping constraints can be explained in terms of mapping cardinality: Mapping Cardinality: One to One: An entity of entity-set A can be associated with at… [Read More]

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • Next Page »

Copyright © 2012 – 2023 BeginnersBook . Privacy Policy . Sitemap