Database Management Systems

Code: MA518 | L-T-P-C: 2-0-2-6

Prerequisites: MA511 Computer Programming and MA512 Data Structures and Algorithms or equivalent

The course aims to introduce database management systems from application perspective. This is expected to helpful for M.Sc. (Mathematics and Computing) students who wish to pursue career in software industry.

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.