Data Definition Language (DDL) is used to specify or create database schema like new database or tables creation along with
Continue readingCategory: DBMS
What is a functional dependency?
Functional Dependency is a relationship between one attribute to another attribute in a Database. Typically, a non-key attribute is dependent
Continue readingAn Entity, Entity Type, Entity Set, Weak Entity Set
Entity An Entity is a real-world object which may have a physical existence like any person, student, etc., or may
Continue readingCCP(Concurrency Control Protocols)
Concurrency Control in Database Management System is a procedure of managing simultaneous operations without conflicting with each other. It is
Continue readingSQL Commands
SQL Commands stands for Structured Query Language Commands. In the era when massive volumes of data are generated, there is
Continue reading2 tier and 3 tier architecture in DBMS
Database Architecture Database Architecture is a representation of DBMS design. It uses programming languages to design a particular type of
Continue readingDifference between TRUNCATE and DELETE Command
Sr No. Delete Command Truncate Command 1. It is a DML (Data Manipulation Language) command. It is a DDL (Data
Continue readingDifference between Intension and Extension in a DataBase
Sr No. Intension Database Extension Database 1. .The intension corresponds to what is specified in the relational schema. The intension
Continue readingDifference between Share lock and Exclusive lock
Lock VSAM record-level sharing has multiple lock structures that are defined in the active storage management subsystem (SMS) configuration. The
Continue readingNormalization in DBMS : What is Normalization
Normalization in DBMS. Learn about normalization and different types. Abstract Normal forms are rules for Database Normalization. Each rule is
Continue reading