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, E R 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, Armstrongs axioms for FDs, closure of a set of FDs, 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