GATE CS Databases Syllabus: Topics and Previous Year Questions
The full GATE CS Databases syllabus — 9 topics. Previous year questions for this subject are being added. Sign up free to practise every question, topic by topic, with the answer to each one.
ER Model Coming soon
Relational Schema Coming soon
Covers: Introduction of RDBMS · Candidate Keys and Super Keys
Relational Algebra Coming soon
Normal Form Coming soon
Covers: Functional Dependencies and Normalization (Membership Set, Equality of FD Sets) · Minimal Cover · Normal Forms · Properties of Decomposition · Decomposition into Higher Normal Forms
Transactions Coming soon
Covers: Recoverable Schedules (Cascadeless, Strict) · Conflict and View Serializability (Serializable Schedules) · Lock-Based and Timestamp Protocols (2PL, Timestamp Ordering) · Recovery (Logs and Checkpoints)
Integrity Constraints Coming soon
SQL Coming soon
Covers: Structured Query Language (SQL): Basics, Joins and Set Operations · SQL: Nested Queries, Aggregation and Views
Tuple Calculus Coming soon
File Organization and Indexing Coming soon
Covers: File Organization and Blocking · Indexing (Single-Level and Multi-Level) · B Trees and B+ Trees
Practise Databases
Sign up free to work through every GATE CS Databases question, topic by topic, with the answer to each one.
Create your free accountSign in