Database Management System

Database Management System

Syllabus & Important Questions

• Syllabus – Download PDF
• Important Question Lists – Download PDF

---

Chapters

1. Chapter 1 – Introduction
2. Chapter 2 – Data Models
   • Important ER diagrams & solutions
3. Chapter 3 – Relational Languages & Relational Model
   • Query examples
   • Relational algebra examples
   • QBE (up to p. 14)
4. Chapter 4 – Database Constraints & Normalization
5. Chapter 5 – Query Processing & Optimization
6. Chapter 6 – File Structure & Hashing
   • RAID
7. Chapter 7 – Transaction Processing
8. Chapter 8 – Crash Recovery
9. Chapter 9 – Advanced Database Concepts

---

Notes & Solutions

• Balkrishna Sir – All Chapter Notes
• All Chapter Important Questions Only

---

SQL & ER Diagram Practice

• ER Diagram Questions
• ER Diagram Last-Moment Tuitions (YouTube)
• ER Diagram Videos
• Basic SQL Queries

---

YouTube Playlists (Core)

• Ch 1: Introduction to DBMS
• Ch 2: Data Models, ER Diagrams
• Ch 3: Relational Languages & Model, SQL Query
• Ch 4: Constraints & Normalization
• Ch 5: Query Processing & Optimization
• Ch 6: File Structure & Hashing
• Ch 7: Transaction Processing
• Ch 8: Crash Recovery
• Ch 9: Advanced Database Systems

---

Further Reading

• Database Management System – Ramakrishnan & Gehrke
• DBMS Korth Solutions Manual
• Tutorials Point Notes (ER Diagram Intro)