Course module

Data Base Management System — DSSSB TGT Computer Science 2026 Section B

Lessons: 205
Duration: 16 hr 7 min
PYQs: 256
Practice: 795

7% of this course's PYQ weight is covered in this module.

Syllabus index

Lessons in this module

205 linked lessons

Basics of DBMS

DBMS Fundamentals

Types & DBA Functions

Data Model, Architecture & Components

ER Diagram

ER Modeling Fundamentals

Cardinalities, Participation & Entity Strength

Conversion of ER Diagram into Relational Model

Relational Model & Functional Dependencies

Basics of Relational Model & Anomalies

Functional Dependencies & Axioms

Keys & Integrity Constraints

Super Key, Candidate Key & Primary Key

Foreign Key & Referential Integrity

Composite & Alternate Keys

Normalization (1NF - BCNF)

Introduction to Normalization & 1NF

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Decomposition Properties & 4NF

Multivalued Dependency (MVD) & 4NF

Lossless Join Decomposition

Dependency Preserving Decomposition

Relational Algebra

Introduction to Query Languages

Unary Operators (Selection & Projection)

Set Operations & Cartesian Product

Join Operations (Inner & Outer)

Rename Operation

Division Operator

SQL

Introduction, Components & Structure

Select, Where, Distinct

Datatypes, Operators & Null

DDL, DML, DCL, TCL & Desc

Order By & Rename Operation (Alias)

Library Functions (Math, Aggregate, String, Date)

Set Operations & Cartesian Product

Join Operations (Inner & Outer)

Group By Clause

Nested & Correlated Subqueries

File Organization & Indexing

Basics & Types of Indexing

B-Trees & B+ Trees (Structure & Insertion)

Deletion in B-Trees & B+ Trees

Transaction Management

Introduction & ACID Properties

Transaction States

Concurrency Control

Introduction to Concurrency Control

Timestamp Ordering Protocols

Lock-Based Protocols & Basic 2PL

Variations of 2PL (Strict, Rigorous, Conservative)

Database Security & Authorization

Introduction to Database Security

Mandatory Access Control (MAC)

Role-Based Access Control (RBAC)

Module lessons

Lessons

DSSSB - Unit Test - Database Management SystemTest

Previous-year questions

PYQ collectionPYQ Questions14 questions PYQ collectionPYQ Questions5 questions PYQ collectionPYQ Questions4 questions PYQ collectionPYQ Questions23 questions PYQ collectionPYQ Questions14 questions PYQ collectionPYQ Questions5 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions21 questions PYQ collectionPYQ Questions9 questions PYQ collectionPYQ Questions6 questions PYQ collectionPYQ Questions15 questions PYQ collectionPYQ Questions19 questions PYQ collectionPYQ Questions8 questions PYQ collectionPYQ Questions27 questions PYQ collectionPYQ Questions4 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions10 questions PYQ collectionPYQ Questions1 questions PYQ collectionPYQ Questions1 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions4 questions PYQ collectionPYQ Questions6 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions15 questions PYQ collectionPYQ Questions4 questions PYQ collectionPYQ Questions13 questions PYQ collectionPYQ Questions9 questions PYQ collectionPYQ Questions35 questions PYQ collectionPYQ Questions4 questions PYQ collectionPYQ Questions31 questions PYQ collectionPYQ Questions5 questions PYQ collectionPYQ Questions8 questions PYQ collectionPYQ Questions11 questions PYQ collectionPYQ Questions4 questions PYQ collectionPYQ Questions124 questions PYQ collectionPYQ Questions8 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions11 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions1 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions6 questions PYQ collectionPYQ Questions256 questions