Database Management Systems

UNIT I

Introduction-Overview of Database System and various Data Models (Hierarchical, Network, and Relational Models), Views of Data, Database Management System, Architecture of DBMS, components of DBMS. Data Independence. Entity-Relationship Model- Entities, Entity Types, Attributes, Relationships, Relationship types, E/R diagram notation.

UNIT II

Relational Data Model- Concept of Relations, Overview of Various Keys, Referential Integrity, and foreign keys. Relational Language- Relational Algebra, Tuple and Domain Relational Calculus, SQL, DDL and DML, embedded SQL. Introduction and basic concepts of PL/SQL. Query Processing and Optimization. Study of various open Source and Commercialized Database Management Systems- MySQL, PostgreSQL, Oracle, DB2, SQL Server

UNIT III

Database Design- Dependencies and Normal forms, Functional Dependencies, 1NF, 2NF, 3NF, and BCNF. Higher Normal Forms-4NF and 5NF. Transaction Management: ACID properties, Serializability, Concurrency Control, Database recovery management. Data Storage and Indexes, Hashing Techniques.

UNIT IV

Advanced Topics- CAP Theorem, Data Security, Object Oriented Database, Web Database, Distributed Database, Data Warehousing, and Mining. NOSql, MongoDB: Introduction, History of MongoDB, Installation and configuration. Key Features. Core servers & tools. Basic commands. Queries & Indexes.

Text Books:

1. Silberschatz, A., Korth, Henry F., and Sudharshan, S., Database System Concepts, 5th Edition, Tata McGraw Hill, 2016.
2. Elmasri, Ramez and Navathe, Shamkant B., Fundamentals of Database Systems 7th Edition,Pearson, 2015.

Reference Books:

1. Date, C. J, Kannan, A. and Swamynathan, S., An Introduction to Database Systems, 8th edition, Pearson Education, 2012.
2. J. D. Ullman, Principles of Database Systems, 2nd Ed., Galgotia Publications, 1999.
3. Vipin C. Desai, An Introduction to Database Systems, West Publishing Co.