----------Archive----------/Database

/INTRODUCTION TO DBMS

Lectures Monday 12:00 - 13:00 C11 Wednesday 10:30 - 11:30 C11 Thursday 15:00 - 16:00 C11 Lab Thursday 09:00 - 10:30 Evaluation 15% Theory Exam 1 15% Theory Exam 3 20% Practical Exam 25% MidSem 25% EndSem Course Instructor Ashish Sureka (TBD Academic Block)       Office Hours: TBD TAs Monika Gupta Dipto Sarkar Vidushi Chaudhary Abhishek Singh

/Resources db-book.com{Book Website} /Exams Exam-1 [04/02/2013]   Midsem   Quiz-2   Lab Exam /Lectures Course Introduction Chapter-1, Chapter-1-extended {Introduction} Part-1 Relational Databases Chapter-2 {Introduction to Relational Model} Chapter-3 {Introduction to SQL} Chapter-4 {Intermediate SQL} Part-2 Database Design Chapter-7 {The Entity-Relationship Approach} Chapter-8 {Relational Database Design}, Normalization[Feb 20], Normalization[Feb 21] Part-3 Data Storage and Querying Basics of Indexing - Sparse and Dense Index [March 6 2013] Chapter-11 {Indexing and Hashing}, B+ Trees, Hashing Part-4 Transaction Management Chapter-14 Transactions Chapter-14-15 Transactions and Concurrency Control Chapter-14-15 Transactions and Concurrency Control - pptx{contains animations} /Problems Problem-1 [(21+23)/01/2013]    Problem-2 [27/01/2013]    Problem-3 [31/01/2013] ER Model - Exercise [11/02/2013] Problems - Functional Dependency B+ Trees [7/03/2013] Problems [17/04/2013] /Tutorials ClassDemo.sql