Course module

Database Management System — HPSC PGT Computer Science (कक्षा 11–12)

Explore the module outline and lessons below. Enroll free to begin studying here.

Lessons: 189
Duration: 15 hr 14 min
PYQs: 355
Practice: 91

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

Syllabus index

Lessons in this module

189 linked lessons

Basics of DBMS

DBMS Fundamentals

Types & DBA Functions

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

Attribute Closure & Equivalence of Sets

Minimal Cover (Canonical Cover)

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

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

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 Problems

Schedules & Conflict Serializability

View Serializability

Recoverability, Cascadeless & Strict Schedules

Concurrency Control

Introduction to Concurrency Control

Lock-Based Protocols & Basic 2PL

Variations of 2PL (Strict, Rigorous, Conservative)

Module lessons

Lessons

HPSC - Unit Test - DBMSTest

Previous-year questions

PYQ collectionPYQ Questions35 questions PYQ collectionPYQ Questions13 questions PYQ collectionPYQ Questions48 questions PYQ collectionPYQ Questions19 questions PYQ collectionPYQ Questions10 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions31 questions PYQ collectionPYQ Questions17 questions PYQ collectionPYQ Questions8 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions28 questions PYQ collectionPYQ Questions21 questions PYQ collectionPYQ Questions13 questions PYQ collectionPYQ Questions1 questions PYQ collectionPYQ Questions35 questions PYQ collectionPYQ Questions4 questions PYQ collectionPYQ Questions7 questions PYQ collectionPYQ Questions7 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions21 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions14 questions PYQ collectionPYQ Questions14 questions PYQ collectionPYQ Questions10 questions PYQ collectionPYQ Questions47 questions PYQ collectionPYQ Questions8 questions PYQ collectionPYQ Questions30 questions PYQ collectionPYQ Questions5 questions PYQ collectionPYQ Questions12 questions PYQ collectionPYQ Questions20 questions PYQ collectionPYQ Questions160 questions PYQ collectionPYQ Questions8 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions11 questions PYQ collectionPYQ Questions6 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions4 questions PYQ collectionPYQ Questions1 questions PYQ collectionPYQ Questions14 questions PYQ collectionPYQ Questions2 questions PYQ collectionPYQ Questions3 questions PYQ collectionPYQ Questions5 questions PYQ collectionPYQ Questions355 questions