| Course Code: CS3103 Course Name: Database Management Systems Prerequisites: NIL Syllabus: Introduction: Purpose of Database and DBMS, Components of DBMS; Relational Languages: Introduction to relational model, Relational Algebra; SQL: Introduction to SQL, Integrity Constraints; Database Design: ER Model, relational model and algebras, Functional Dependencies, Normalization. Transaction Management: Transactions, ACID properties, concurrency control, recovery system; Storage Management System: Physical storage systems, File Organization, Indexing; Texts: 1. Abraham Silberschatz, Henry F. Korth, S. Sudarshan, Database Systems Concepts, McGraw Hill Edition, 2019. 2. Raghu Ramakrishnan, Johannes Geherke, Database Management Systems, McGraw Hill, 2014. 3. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom, Database Systems: The Complete Book, 2nd Edition, Pearson, 2013 |