Course module

Unit 6 | Database Management System — Bihar STET 2026 Computer Science — General Paper + Paper II

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

Lessons: 204
Duration: 15 hr 2 min
PYQs: 45
Practice: 423

Syllabus index

Lessons in this module

204 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

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

Fifth Normal Form (5NF)

Lossless Join Decomposition

Dependency Preserving Decomposition

File Organization & Indexing

Basics & Types of Indexing

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

Transaction Management

Introduction & ACID Properties

Transaction States

Concurrency Problems

Schedules & Conflict Serializability

View Serializability

Concurrency Control

Introduction to Concurrency Control

Timestamp Ordering Protocols

Lock-Based Protocols & Basic 2PL

Previous-year questions

Lessons in this module

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

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

Fifth Normal Form (5NF)

Lossless Join Decomposition

Dependency Preserving Decomposition

File Organization & Indexing

Basics & Types of Indexing

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

Transaction Management

Introduction & ACID Properties

Transaction States

Concurrency Problems

Schedules & Conflict Serializability

View Serializability

Concurrency Control

Introduction to Concurrency Control

Timestamp Ordering Protocols

Lock-Based Protocols & Basic 2PL

Previous-year questions

Explore the course