| Lecture No : Date |
Title & Link to notes |
Description |
| 1 : Jan 8, 2019 |
Introduction |
(Pages 1-2) |
| 2 : Jan 18, 2019 |
Concepts, Terms and Data Models |
|
| 3 : Jan 19, 2019 |
EER, Relational Model and Constraints |
(Pages 11-15) |
| 4 : Feb 1, 2019 |
Mapping ER model into Relational model |
|
| 5 : Feb 1, 2019 |
Relational Algebra and Intro to Normalization Theory |
|
| 6 : Feb 2, 2019 |
Functional Dependency Inference Rules, 1 NF and 2 NF |
|
| Minor 1: Feb 11, 2019 |
Minor 1 Exam Paper |
|
| 7 : Mar 1, 2019 |
Normalization: 3 NF and higher |
|
| 8 : Mar 1, 2019 |
Database Storage and Indexing |
|
| 9 : Mar 8, 2019 |
Query Processing - SELECT Query |
|
| 10 : Mar 8, 2019 |
External Sorting and JOIN Query |
|
| 11 : Mar 9, 2019 |
Hash Join and Size Estimation |
|
| Minor 2 : Mar 17, 2019 |
Minor 2 Exam Paper |
|
| 12 : Mar 29, 2019 |
Size Estimation - Joins |
|
| 13 : Mar 29, 2019 |
Equivalence Rules for Relational Algebra |
|
| 14 : Mar 29, 2019 |
Heuristics and Materialized Views |
|
| 15 : Mar 30, 2019 |
Transaction Processing, ACID properties |
|
| 16 : Apr 12, 2019 |
Concurrency Subsystem, Conflict and View Serializability |
|
| 17 : Apr 13, 2019 |
Transaction Isolation and Atomicity, Recoverable and Cascadeless Schedules, Lock-based Protocols: 2PL |
|
| 18 : Apr 19, 2019 |
Isolation and Deadlock problem: Prevention, Timestamp based Ordering Protocol (TOP), TOP vs 2PL |
|
| 19 : Apr 19, 2019 |
Recovery Subsystem: Shadow-Copy scheme and Log-based recovery |
|
| Major : Apr 29, 2019 |
Major Exam Paper |
|