DBMS Study Resource – GATE CSE 2018

ER‐model. Relational model: relational algebra, tuple calculus, SQL. Integrity constraints, normal forms. File organization, indexing (e.g., B and B+ trees). Transactions and concurrency control.

• Choose one of:
  • Navathe
  • DBMS by Raghu Ramakrishnan 2nd Edition [Buy from Amazon]
  • Korth [Buy from Amazon]

• SQL and other portions
• ER to Relational Model
• Normal Forms Quick View
• Normalization Slides
• Canonical Cover
• Indexing
• Single Level Indexing
• Concurrency Control
• B+ Tree Insertion and Deletion