Syllabus :
ER-model, Relational model (relational algebra, tuple calculus), Database design (integrity constraints, normal forms), Query languages (SQL), File structures (sequential files, indexing, B and B+ trees), Transactions and concurrency control.
There are following Books of Database Management System with free download for GATE :
There is following important, excellent & very useful lecture notes with free download :