Learn Databases, with pictures you can poke.
Short concepts, every formula in one place, interactive animations, and the question types that keep repeating in past GATE papers.
Syllabus. ER-model. Relational model: relational algebra, tuple calculus, SQL. Integrity constraints, normal forms. File organisation, indexing (for example B and B+ trees). Transactions and concurrency control.
Study order
Highest yield first. Tick a topic when you are done with it.
0 of 7 topics done
SQL
Output-of-a-query questions are the most frequent database marks. Know the evaluation order, aggregates with NULL, and nested queries.
Functional Dependencies
The engine of normalisation. Closure, candidate keys and canonical cover appear almost every year and are quick marks once the method is automatic.
Normal Forms & Decomposition
Highest normal form, lossless join and dependency preservation are guaranteed questions. All three reduce to closures.
Transactions & Concurrency Control
Serializability, recoverability and 2PL are the hardest and most frequent database questions, but the checks are mechanical.
File Organisation & Indexing
Numerical questions on blocking factors, index sizes and B+ tree order or height are routine and fully formulaic.
ER Model, Relational Model & Keys
Short but easy marks: count tables from an ER diagram, count super keys, and decide which foreign key action a delete triggers.
Relational Algebra & Calculus
Queries are asked in algebra form: what does an expression compute, how many rows can it return, which expressions are equivalent.
What gets asked, at a glance
Most frequent question types across topics (rating is approximate).
Importance and frequency ratings are my reading of recurring GATE CSE patterns, not an official count. Cross-check against a PYQ set before relying on them for exact marks.
Frequently asked questions
How many marks does Databases carry in GATE CSE?
By my estimate about 8 to 10 marks per paper. This is an estimate from recurring patterns in past papers, not an official count, and it varies from year to year.
What topics are in Databases for GATE CSE?
ER Model, Relational Model & Keys; Relational Algebra & Calculus; SQL; Functional Dependencies; Normal Forms & Decomposition; Transactions & Concurrency Control; File Organisation & Indexing.
Which Databases topics are most important for GATE?
The highest-yield topics are SQL; Functional Dependencies; Normal Forms & Decomposition; Transactions & Concurrency Control; File Organisation & Indexing. Importance is my estimate from recurring question patterns.
Where can I find solved GATE Databases previous year questions?
This page links to 75 previous year question entries from 2011 to 2025, each with the official answer key and a worked solution.