Syllabus

ER-model, relational model (relational algebra, tuple calculus), Database design (integrity constraints, normal forms), Query languages (SQL). File structures (sequential files, indexing, Band B+ trees), Transactions and concurrency control.

Analysis of Previous GATE Papers

Exam Year 03 04 05 06 07 08 09 10 11 12 13
1 Mark Questions 2 2 3 1 0 1 0 2 0 2 0
2 Mark Questions 3 5 4 4 6 5 5 2 2 5 3
Total Marks 8 12 11 9 12 11 10 6 4 12 6

 

Exam Year 2014
Set Set 1 Set 2 Set 3
1 Mark Questions 2 2 2
2 Mark Questions 3 3 3
Total Marks 8 8 8