Transaction-processing systems usually allow multiple transactions to run concurrently. Allowing multiple transactions to update data concurrently causes several complications with consistency of the data. Ensuring
Author: Ashutosh Tripathi
Difference between Normalization and Normal Forms
Normalization: Normalization is the systematic process applied on the relations to reduce the degree of redundancy. Normalization is defined as systematic because it always gives
Implementation of Atomicity and Durability using Shadow Copy
The recovery-management component of a database system can support atomicity and durability by a variety of schemes. Here we are going to learn about one of
Convert local path to UNC (Universal) File Path using Java Script ActiveXObject
in razor view engine add the following line to support ActiveXObject: @using System.Web.Script.Serialization
DBMS Notes for GATE 2020
Relational Model Relational Algebra – Degree, Cardinality, Domain, Union Compatibility and Operators Cartesian Product Join Operators in DBMS Join Conditions – Natural Join, On Condition,
Types of Functional Dependencies in Normalization
Functional Dependency: In Relational database, Functional dependency is denoted as X -> Y where X:Determinant and Y: Dependent. So, as per the concept the value of Y