ExamAdda LogoExamAdda
CompilerDSA Animations
JAVASCRIPTMYSQL1MYSQLPYTHONINTERVIEWNODEJSDBMSDBMS1ROADMAPSDSA

Basic DBMS

  • Introduction of DBMS
  • DBMS vs File System
  • Types of Databases
  • Database Architecture
  • Data Models
  • Schema vs Instance
  • Constraints in DBMS
  • Functional Dependencies

ER Model

  • Basic Concepts
  • ER Diagram
  • Structural Constraints
  • Weak Entity
  • Relationship Types
  • Generalization
  • Specialization
  • Aggregation
  • Enhanced ER Model (EER)
  • Mapping ER to Relational Model

Normalization

  • Introductions
  • Redundancy Problem
  • 1NF
  • 2NF
  • 3NF
  • BCNF
  • 4NF
  • 5NF

Relational Model

  • Codd’s Rules
  • Relational Algebra
  • Relational Calculus
  • Domain & Tuple Relational Calculus
  • Integrity Constraints

Transactions

  • What is Transaction?
  • Transaction States
  • ACID Properties
  • Transaction Lifecycle

Concurrency Control

  • Types of Schedules
  • Serial & Non-Serial Schedule
  • Serializability
  • Lock-Based Protocol
  • Two-Phase Locking (2PL)
  • Timestamp-Based Protocol
  • Multiple Granularity Locking
  • Graph-Based Protocol
  • Phantom Read
  • Dirty Read
  • Thomas Write Rule

Indexing in DBMS

  • Single-Level Index
  • Multi-Level Index
  • B-Tree
  • B+ Tree
  • Bitmap Index
  • Inverted Index
  • Clustered vs Non-Clustered Index
  • Hash Indexing

File Organization

  • Heap File
  • Sequential File
  • Hash File
  • Disk Storage Structure
  • Buffer Management

Deadlock

  • Causes of Deadlock
  • Detection
  • Prevention
  • Avoidance

Recovery Techniques

  • Log-Based Recovery
  • Checkpointing
  • Shadow Paging
  • Database Backup
  • Database Restore

Distributed Database

  • Distributed DBMS
  • Fragmentation
  • Replication
  • Distributed Transactions
  • Two-Phase Commit Protocol

Big Data

  • Data Warehousing
  • OLTP vs OLAP
  • Data Lake
  • ETL Process
  • Sharding
  • Replication

Security in DBMS

  • Authentication
  • Authorization
  • Role-Based Access Control
  • Encryption
  • SQL Injection

Performance Tuning

  • Query Optimization
  • Index Optimization
  • Partitioning
  • Caching
  • Connection Pooling

DBMS1 Tutorial

Learn DBMS1 with our comprehensive tutorials

Basic DBMS

8 topics →

ER Model

10 topics →

Normalization

8 topics →

Relational Model

5 topics →

Transactions

4 topics →

Concurrency Control

11 topics →

Indexing in DBMS

8 topics →

File Organization

5 topics →

Deadlock

4 topics →

Recovery Techniques

5 topics →

Distributed Database

5 topics →

Big Data

6 topics →

Security in DBMS

5 topics →

Performance Tuning

5 topics →

ExamAdda LogoExamAdda Tech

Your comprehensive destination for learning programming, web development, data science, and modern technologies. Master coding with our in-depth tutorials and practical examples.

Support

  • About Us
  • Contact Us
  • Privacy Policy
  • Terms of Service

Connect With Us

Follow us on social media for the latest tutorials, tips, and programming updates.

© 2026 ExamAdda Tech. All rights reserved.

Privacy PolicyTerms of ServiceCookie Policy