Overview of Database Management Systems
Database Management
Users of Database Management System
Three Layered Architecture
Data Independence

Unit 02: E-R Modeling

Waterfall Model
Entities
Relationships

Unit 03: Relational Data Model

Relational Data Model
Operations on Tables
Relational Data Model- Objects
Set Operations
Update Operations
Constraints

Unit 04: Normal Forms

Data base design
Anomalies
Decomposition
Why Normal Forms
E-R to Relational Conversion Principles

Unit 05: Introduction to SQL

Data Manipulation Language
Union Operator

Unit 06: Data on Disk

Physical Storage

Unit 07: Transaction Processing - I

Storage types in a Database System
Failure Types
Storage Hierarchy

Unit 08: Transaction Processing - II

Commit, Atomicity and Durability
Concurrency: The Problem
Properties of Transactions

Unit 09: Log Based Recovery Technique

Log Data Structure
Recovering from failure

Unit 10: Write Ahead Logging Technique

Write Ahead Logging (WAL) Concepts
Buffer Management
OS and Databases

Unit 11: Check pointing and Shadow Paging

Check pointing: A simple solution
Recovering using Checkpoints
Shadow Paging

Unit 12: Concurrency Control

Schedules
Serial and Non-serials Schedules
Conflict Serialiazability
Lock-Based Protocols
Two-Phase Locking Protocol

Unit 13: Multi Granualarity Locking

Introduction
Intention Mode Locks
MGL Scheme

Unit 14: Transaction Processing - III

  Recoverability and cascading rollbacks
  Phantom Phenomenon: Insert, Delete
  Degree Two Consistency

Unit 15: Distributed Databases

Distributed Database Concepts
Advantages of Dhaka Distribution
Data Fragmentation
Transparency

Unit 16: Recovery in Distributed Databases System

Introduction
D.T.P: Software Modules
Failure Modes
Commit Protocol: Objectives

Unit 17: 2 Phase Commit: Failure Handling

Failure of a participating site
Request coordinator for failure recovery

Unit 18: Client-Server Systems

Client/Servers in Databases
ODBC