CS 246	Database Management Systems Laboratory	0-0-4-4
Pre-requisites : CS203, CS204 Using a relational DBMS: Writing SQL queries, accessing a DBMS from an external application. Implementing of parts of DBMS such as various file organizations, indexing methods (Tree/ Hash/ Bitmap), external sorting algorithms, concurrency control schemes, and crash recovery schemes. Non-relational DBMS; performance comparison of a non-relational DBMS with a relational DBMS for an application. Text Book: 1. H. Garcia-Molina, J. Ullman, J. Widom, Database System Implementation, 2nd Edition, Pearson, 2002. 2. J. Groff and P. Weinberg, SQL Complete Reference, McGraw Hill, 3^rd Edition, 2017. 3. P. Sadalage and M. Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison Wesley, 2012.