Date | Topic | Chapters Covered | Exercise Due |
Week-1-Lec-1 | Introduction to Basic Concepts | C1 (C1) | - |
Week-1-Lec-2 | Database System Architecture | C2 (C2) | - |
Week-2 | ER model, UML and Relational Model | C3 (C3) | Exercise 1 due Week-3-Lec-1 |
Week-3 | Oracle Fundamentals | Classnotes | (Week-3-Lec-1 Quiz 1) |
Week-4 | Relational Model and Relational Algebra | C7 (C6) | - |
Week-5 | Relational language SQL | C8 (C7) | Exercise 2 due Week-5-Lec-1 |
Week-6 | Physical structures | C5 (C4 and C5) | Exercise 3 due Week-6-Lec-2 |
Week-7-Lec-1 | Review of first seven chapters, B-tree and extendible hashing | - | Exercise 4 due Week-7-Lec-1 |
Week-7-Lec-2 | Midterm Exam | C1 to C8 not C4 (C1 to C7) | - |
Week-8 | Relational Calculus and Normal Forms | C9 (C8) and C14 (C12) | - |
Week-9-Lec-1 | Database Integrity | C8 (C12) | Exercise 5 due Week-9-Lec-1 |
Week-9-Lec-2 | Oracle, DB2 and implementation issues | C10 (C9) | project #1 discussion |
Week-10 | Hierarchical model, IMS and MUMPS concepts | Classnotes (C11) | Exercise 6 due Week-11-Lec-2, project #2 discussion |
Week-11-Lec-1 | Hypertext model, HTML and XML | Classnotes | - |
Week-11-Lec-2 | WebBase Interface and ODBC concepts | Classnotes | (Week-11-Lec-2 Quiz 2) project #2 discussion |
Week-12 | Network Data Model and Object-oriented database concepts | C11 and C12 (C10 and C22) | - |
Week-13-Lec-1 | Common Gateway Interface for Web Database | Classnotes | - |
Week-13-Lec-2 | Data Mining | - | - |
Week-14 | Database design and comparison of data models | C9 and C12 (C12, C14 and C22.8) | Early submission of projects (+3 bonus points) Week-14-Lec-1 |
Week-15-Lec-1 | Review | C1-C12,C26.2 not C4 (C1-C8, C10-C12, C14, C22) and classnotes | Miniproject due Week-15-Lec-1 |
Week-15-Lec-2 | Final Exam | C1-C12, C26.2 not C4 (C1-C8, C10-C12, C14, C22) and classnotes | Late submission of miniprojects (-2 penalty points, after final exam, no miniprojects may be submitted) |