Database Management Systems

Database Management Systems - Spring 2019

MTech (CS) : 1st Year, 2nd Semester

GENERAL INFORMATION

Syllabus: From Student's Brochure

Marks Distribution: MID-SEMESTER - 30; SEMESTER - 50; ASSIGNMENT - 10; PROJECT - 10

Venue: Seminar Room, 4th Floor, MIU, PJAB; CSSC Lab - 2, 4th Floor, S N Bose Bhavan (Library Building)

Timings: Monday (14:15 - 16:00), Thursday (14:15 - 16:00)

Coursepages: Home, Piazza

LECTURE DETAILS

Topic	Lecture	Date	Lecture Topics	Notes	Resources
0	1-2	03-01-2019	Introduction to Databases	Slides [PDF]	[R1, R2, R3, R4, R5]
I	3-4	07-01-2019	Mathematical Preliminaries	Slides [PDF]	[R2, Vardi (1982)]
II	5-6	14-01-2019	Relational Data Model	Slides [PDF]	[R2, R4, Codd (1970)]
III	7-8	21-01-2019	SQL - Basic Features	Slides [PDF]	[R6, R7, R8]
IV	9-10	24-01-2019	SQL - Advanced Features	Slides [PDF]	[R6, R7, R8]
V	11-12	31-01-2019	Database Normalization - I	Slides [PDF]	[Codd (1970), Codd (1971), Codd (1974), Fagin (1977), Fagin (1979), Fagin (1981), Zaniolo (1982), Date (2002), Date (2006)]
...	13-14	04-02-2019	Database Normalization - II	...	...
Mid-semester examination break (18-02-2019 to 22-02-2019)					Mid Semester Paper, Answer Keys
VI	15-16	25-02-2019	Query Optimization - I	Slides [PDF]	[R9]
...	17-18	28-02-2019	Query Optimization - II	...	...
...	19-20	04-03-2019	Query Optimization - III	...	...
VII	21-22	07-03-2019	Database Tuning	Slides [PDF]
VIII	23-24	14-03-2019	Transaction Processing - I	Slides [PDF]	[R2]
...	25-26	15-03-2019	Transaction Processing - II	...	...
IX	27-28	18-03-2019	Concurrency Control	Slides [PDF]	[R2]
X	29-30	28-03-2019	Database Recovery - I	Slides [PDF]	[R2, Mohan (1992)]
...	31-32	01-04-2019	Database Recovery - II	...	...
XI	33-34	04-04-2019	Big Data Management	Slides [PDF]	[R10, Cattell (2011), Mirrokni (2017)]
XII	35-36	08-04-2019	MongoDB	Slides [PDF]	[MongoDB Documentation]
XIII	37-38	11-04-2019	Case Study and Review
Final semester examination (03-05-2019)					Final Semester Paper, Answer Keys

COURSE PLAN

No Dues

ASSIGNMENTS

PROJECTS

Set	Due Date
Projects	30-04-2019

OTHERS

REFERENCES

C. J. Date, An Introduction to Database Systems, Pearson Education, Inc., 8th Edition, 2006.
A. Silberschatz, H. F. Korth and S. Sudarshan, Database System Concepts, Tata McGraw-Hill, 6th Edition, 2011.
R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, Pearson Education, Inc., 4th Edition, 2004.
R. Ramakrishnan and J. Gehrke, Database Management Systems, McGraw-Hil, 3rd Edition, 2007.
H. Garcia-Molina, J. D. Ullman and J. Widom, Database Systems: The Complete Book, Pearson Education, Inc., 2nd Edition, 2009.
G. Harrison and S. Feuerstein, MySQL stored procedure programming. O'Reilly Media, Inc., 2006.
K. Loney, Oracle Database 11g - The Complete Reference, McGraw-Hill, Inc., 2008.
I. Bayross, SQL, PL/SQL: The Programming Language of Oracle, BPB Publications, 6th Edition, 2010.
G. Fritchey, SQL Server Query Performance Tuning, Apress, 4th Edition, 2011.
P. J. Sadalage and M. Fowler, NoSQL distilled: a brief guide to the emerging world of polyglot persistence, Pearson Education, Inc., 1st Edition, 2013.