At a Glance
- Credits: 3 (2+0+1)
- Exam Split: 70% (Assignments 20, Quizzes 10, Practicals 15, Attendance 5, Midterm 10, Viva 10) / 30%
- Lab Heavy: Yes 🔬
- Units: 5
Roadmap
Understand how data is stored, retrieved, and protected from corruption. You'll design schemas, write SQL, and grasp the mechanics of transactions.
Panic Mode:
Units Breakdown
Unit 1: Introduction to Database System▼
Why it matters: Sets the stage for why we don't just use Excel files.
📖 Elmasri & Navathe Ch 1-2
- ✦ DB vs DBMS
- ✦ Architecture, Users/roles
- ✦ Schemas & instances, Data models
- ✦ Data independence
- ✦ Advantages/disadvantages
Unit 2: ER Modeling▼
Why it matters: How to translate real-world requirements into a data blueprint.
📖 Elmasri & Navathe Ch 3, 7
- ✦ Entities/attributes/relationships
- ✦ Keys, ER diagrams
- ✦ Weak entities, Generalization/aggregation
- ✦ CODD's 12 rules
Unit 3: Relational Model & SQL▼
Why it matters: The universal language for talking to databases.
📖 Elmasri & Navathe Ch 4-5
- ✦ Relational algebra & calculus
- ✦ Basic/nested queries, Aggregates, NULLs
- ✦ Joins, Outer joins
- ✦ Integrity constraints
Unit 4: Database Design▼
Why it matters: Prevents data duplication and massive update headaches.
📖 Elmasri & Navathe Ch 14-15
- ✦ Schema refinement, Anomalies
- ✦ Functional dependencies
- ✦ 1NF→BCNF, Lossless join
- ✦ Dependency preservation, MVDs, 4NF/5NF
Unit 5: Transactions & Concurrency▼
Why it matters: Ensures the bank doesn't lose your money when the power goes out.
📖 Elmasri & Navathe Ch 20-22
- ✦ ACID properties
- ✦ Schedules, Serializability
- ✦ Locking, Timestamps, Deadlock
- ✦ Recovery, Shadow paging