Purpose of Database System, Views of data, Data models, Database Management system ,Three schema architecture of DBMS, Components of DBMS. Entity Relationship Model ,Conceptual data modeling ,motivation, entities, entity types, attributes, relationships, relationship types, Entity Relationship diagram notations, Examples

Relational Data Model ,keys, referential integrity and foreign keys, Relational Algebra ,SQL fundamentals, Introduction, data definition in SQL, table, key and foreign key definitions, update behaviors , Views, Triggers, Joins, Constraints, Stored Procedure, Intermediate SQL, Advanced SQL features, Embedded SQL, Dynamic SQL

Dependencies and Normal forms , Functional Dependencies, Armstrong's axioms for FD's, closure of a set of FD's, minimal covers, Non loss decomposition, First, Second, Third Normal Forms, Dependency Preservation, Boyce Codd Normal Form, Multivalued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form

Transaction Concepts, ACID Properties, Schedules, Serializability, Concurrency Control, Need for Concurrency, Locking Protocols, Two Phase Locking, Deadlock, Transaction Recovery, Save Points, Isolation Levels, SQL Facilities for Concurrency and Recovery.

Data Storage and Indexes, RAID, File organization-Indexing and Hashing , Ordered Indices, B plus tree Index Files, B tree Index Files, Static Hashing ,Dynamic Hashing. Query Processing Overview, Algorithms for Selection and Sorting Basics of MongoDB, Procedural Language