CS344 | DATABASES | 3-0-0-6 |
Pre-requisites : CS201, CS204 |
Syllabus : Data models with emphasis on the relational model Database design with E-R modelRelational algebra and calculus query Languages (specifically SQL) RDBMS design File & system structure: indexed sequential, hashed, dynamic hashed, B-treesQuery processing Concurrency control error recovery security Case studies like RACLE, Mysql, etc. Introduction to Open Database Connectivity, Client-Serverenvironment etc. |
Texts : 1. A. Silberschatz, H. F. Korth and S. Sudarshan, Database System Concepts, 5/e, McGraw Hill, 2006. 2. R. Ramakrishnan and J. Gehrke, Database Management Systems, 3/e, McGraw Hill, 2003 |
References : 1. Elmasri R, Navathe S B, Fundamentals of Database Systems, Benjamin Cummings Publishing Company, 1994. 2. ONeil P., Database : Principles, Programming, Performance, Morgan Kaufmann, 1994. 3. Theorey T J, Database Modeling & Design, 2/e, Morgan Kaufmann Publishers, 1994. 4. Melton J, Simon A R, SQL: A Complete Guide, Morgan Kaufmann Publishers, 1993. 5. H. GarciaMolina, J. D. Ullman and J. Widom, Database Sytems The Complete Book,1/e, Pearson Education, 2007 |