| Course Code: CS246 Course Name: Database Management Systems Laboratory Prerequisites: CS203, CS204 Syllabus: 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. References: 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, 3rd Edition, 2017. 3. P. Sadalage and M. Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison Wesley, 2012. |