🗄️
GATE CS Databases
Syllabus structure & chapters
Complete syllabus outline for GATE CS Databases. Click on any chapter below to explore subtopics, key concept highlights, expected questions, and start practicing mock tests specifically customized for GATE CS preparation.
ER Model
Entities, Attributes and Relationships, ER Diagrams and Conversion to Tables
View Chapter Details →
Relational Model
Relational Algebra and Tuple Calculus, Integrity Constraints and Keys
View Chapter Details →
SQL
DDL, DML and DCL, Joins, Subqueries, Aggregates, Set Operations and Nested Queries
View Chapter Details →
Normalisation
Functional Dependencies, 1NF, 2NF, 3NF and BCNF, Lossless Join and Dependency Preservation
View Chapter Details →
Transactions and Concurrency
ACID Properties, Serialisability, Locking Protocols: 2PL, Recovery: Log-Based Recovery, Checkpoints
View Chapter Details →