MA 518    Database Managment Systems (2 0 2 6)
Pre-requisites: MA 511  Computer Programming; MA 512  Data Structures and Algo.

Lab timings: Mon (10:00 - 12:00 Noon)    
Class timings: Mon (3:00 - 3:55 pm); Tue (2:00 - 2:55 am)     Room no: 2202

Syllabus :
Data models with emphasis on the relational model;
Database design with E-R model; From E-R model to relational database design;
Relational algebra and calculus;
SQL queries, constraints, triggers;
Database application development: JDBC, SQLJ, Stored procedures;
Internet applications: HTML, XML, Three-Tier application architecture;
Schema refinement and normal forms;
Physical database design and tuning;
Security authorization.

Texts :
1. R. Ramakrishnan and J. Gehrke, Database Management Systems, 3rd Edition, McGraw Hill, 2003
2. P. DuBois, MySQL, 4th Edition, Addison Wesley, 2009.

References :
1. A. Silberschatz, H.F. Korth and S. Sudarshan, Database System Concepts, 5th Edition, McGraw Hill, 2006.
2. S. Feuerstein and B. Pribyl, Oracle Pl/SQl Programming, 5th Edition, O'Reilly, 2009.
3. J. Greenspan and B. Bulger, MySQL/PHP Database Applications, M&T Books, 2008.

TA :
Sachin Sahu (sachinsahu@iitg.ac.in)