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

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]

Posted Under: DBMS

DBMS Transaction States

By Chaitanya Singh

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]

Posted Under: DBMS

DBMS Aggregration

By Chaitanya Singh

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]

Posted Under: DBMS

DBMS Specialization

By Chaitanya Singh

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]

Posted Under: DBMS

DBMS Generalization

By Chaitanya Singh

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]

Posted Under: DBMS

DBMS – Three Level Architecture

By Chaitanya Singh

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]

Posted Under: DBMS

DBMS Architecture

By Chaitanya Singh

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]

Posted Under: DBMS

Concurrency Control in DBMS

By Chaitanya Singh

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]

Posted Under: DBMS

Transaction Management in DBMS

By Chaitanya Singh

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]

Posted Under: DBMS

What is an attribute in DBMS? – Definition and explanation

By Chaitanya Singh

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]

Posted Under: DBMS

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

By Chaitanya Singh

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]

Posted Under: DBMS

Deadlock in DBMS

By Chaitanya Singh

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]

Posted Under: DBMS

Constraints in DBMS

By Chaitanya Singh

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]

Posted Under: DBMS

Domain constraints in DBMS

By Chaitanya Singh

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]

Posted Under: DBMS

Mapping constraints in DBMS

By Chaitanya Singh

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]

Posted Under: DBMS

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

Copyright © 2012 – 2022 BeginnersBook . Privacy Policy . Sitemap