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-Intermediate SQL-Advanced SQL features -Embedded SQL- Dynamic SQL, CASE Studies- Oracle:Database Design and Querying Tools; SQL Variations and Extensions

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+ tree Index Files – B tree Index Files – Static Hashing – Dynamic Hashing. Query Processing Overview. MongoDB, Database creation and manipulation, Indexing and orderingCASE Studies- Oracle,DB2: Storage and Indexing