Skip to main content
C C++ Java Python PHP C# HTML CSS JavaScript Bootstrap Node.js Express.js React.js Next.js Tailwind TypeScript Dart Angular Vue.js Spring Boot Django Flask ASP.NET Material UI Chakra UI Sass MongoDB MySQL Oracle C C++ Java Python PHP C# HTML CSS JavaScript Bootstrap Node.js Express.js React.js Next.js Tailwind TypeScript Dart Angular Vue.js Spring Boot Django Flask ASP.NET Material UI Chakra UI Sass MongoDB MySQL Oracle
SQL Server Firebase PostgreSQL MariaDB Swift Kotlin React Native R Julia Scala NLP ML DP NN Gen AI JUnit Jest Pytest Selenium Cypress AWS Azure Google Cloud Stack Queue Linked List Trees Graphs SQL Server Firebase PostgreSQL MariaDB Swift Kotlin React Native R Julia Scala NLP ML DP NN Gen AI JUnit Jest Pytest Selenium Cypress AWS Azure Google Cloud Stack Queue Linked List Trees Graphs
Core GATE CSE Subjects 22 topics High

DBMS

GATE CSE DBMS — ER models, relational algebra, SQL, normalization, and transactions.

Learning outcomes

  • Translate ER to relations
  • Write relational algebra and SQL for GATE-style queries
  • Normalize up to 3NF/BCNF on small schemas
  • Test serializability of a schedule

Overview

DBMS questions mix SQL/algebra, keys and NFs, and transaction schedules (conflict serializability, 2PL).

You should be able to write a small query and test a decomposition for lossless join and dependency preservation.

This subject page is the landing URL linked from the GATE hub.

Revision map

  1. 1. ER & relational model
  2. 2. Algebra & SQL
  3. 3. Normalization
  4. 4. Indexing
  5. 5. Transactions
  6. 6. PYQ drill

Related resources

Full programming courses are live. Use them for the coding side of GATE CSE while subject notes expand.