Schedule
Please note: This syllabus is prepared only as a guideline. The course structure and contents may change during the semester based on the requirements of the students and the course itself.
| Week | Topics |
| Jan 1 - Jan 3 | Introduction to DBMS (Chapter 1) |
| Jan 6 - Jan 10 | Relational Data Model (Chapter 2), Introduction to SQL (Chapter 3) |
| Jan 13 - Jan 17 | SQL (contd.)/Intermediate SQL (Chapters 3,4) |
| Jan 20 - Jan 24 | SQL (contd.)/Advanced SQL (Chapters 4,5) |
| Jan 27 - Jan 31 | Formal Relational Query Languages (Chapter 6) |
| Feb 3 - Feb 7 | Database Design and E-R Model (Chapter 7) |
| Feb 10 - Feb 14 | Database Design and Normalization (Chapter 8) |
| Feb 17 - Feb 21 | Database Design/Mid-Semester Review |
| Feb 24 - Feb 28 | Mid-Semester Exam |
| Mar 3 - Mar 7 | Application Design and Development (Chapter 9) |
| Mar 10 - Mar 14 | Storage and File Structures/ Indexing and Hashing (Chapters 10,11) |
| Mar 17 - Mar 21 | Indexing and Hashing (Chapter 11) |
| Mar 24 - Mar 28 | Query Processing/Query Optimization (Chapters 12,13) |
| Mar 31 - Apr 4 | Transactions (Chapter 14) |
| Apr 7 - Apr 11 | Transactions (contd.)/Concurrency Control (Chapters 14,15) |
| Apr 14 - Apr 18 | Concurrency Control/Review (Chapter 15) |
Academic Integrity
All assignments and projects must be your own individual work, unless specified as team efforts. You are encouraged to learn from each other but copying is strongly discouraged. All solutions turned in for credit are to be your individual work and should demonstrate your problem solving skills. The instructor reserves the right to question a student orally or in writing and to use his evaluation of the student's understanding of the assignment and of the submitted solution as evidence of cheating. Violators of this policy may be faced with penalties.
Vineeth N Balasubramanian
Office # 57, IIT-Hyderabad
Ordnance Factory Estate Campus
Yeddumailaram, Medak Dist
Andhra Pradesh - 502205, INDIA
Ph (Off): +91-40-23017115