Relational Database:Purpose of Database System – Views of Data – Data Models – Database System Architecture – Introduction to Relational Databases – Relational Model – Keys – Relational Algebra – Relational Calculus – SQL Fundamentals

DatabaseDesign:Entity-Relationship Model – ER Diagrams – Functional Dependencies – Non-Loss Decomposition Functional Dependencies – First Normal Form – Second Normal Form – Third Normal Form – Dependency Preservation – Boyce/Codd Normal Form.

TransactionManagement:Transaction Concepts – ACID Properties – Serializability – Transaction Isolation Levels – Concurrency Control – Need for Concurrency – Lock-Based Protocols – Deadlock Handling. Recovery System – Failure Classification – Recovery Algorithm.

ImplementationTechniques:Overview of Physical Storage Media – RAID – File Organization – Organization of Records in Files – Indexing and Hashing – Ordered Indices.

Distributed and NoSQL Database:Overview of Distributed Databases – Data Fragmentation – Replication – XML Databases – XML Schema – NOSQL Database: Characteristics– Types of NoSQL Datastores: Column Oriented, Document, Key-Value and Graph Types – Applications – Current Trends.