Contents

1. Basic Concepts

1. Introduction

2. Database and Need for DBMS

3. Characteristics, Users, Views and Schema

3.1 Characteristics

3.2 Users

3.3 View of Data

3.4 Schema

4. Three-Tier Architecture

5. Introduction to Parallel, Distributed Databases, Mobile Databases and Cloud Databases

5.1 Introduction to Parallel Databases

5.2 Introduction to Distributed Database System

5.3 Introduction to Mobile Database

5.4 Introduction to Cloud Database

6. Models

6.1 Relational Data Model

6.2 Operations in Relational Model

6.3 Object - Based Models

7. Advantages and Disadvantages of Each Model

2. Data Modeling and Relational Database Design

1. Introduction

1.1 Entity

1.2 Attribute

2. Relationship

3. Attributes, Relationship Set, Keys

3.1 Attribute

3.2 Relationship Set

3.3 Degree of a Relationship Set

3.4 Primary Keys of Relationship Sets

3.5 Keys

3.6 Non-key Attributes

4. Codd’s Rules

5. Generalization, Aggregation, ER diagram

5.1 ER Model for Banking Business

6. Normalization

6.1 First Normal Form

6.2 Second Normal Form

6.3 Third Normal Form (3NF)

6.4 Boyce and Codd Normal Form (BCNF)

7. Introduction to SQL, DDL, DML Queries

7.1 Introduction to SQL

7.2 Types of SQL Statements (DDL, DML, DCL, TCS, SCS Commands)

7.3 Data Control Language (DCL) Statements

7.4 Transaction Control Statement (TCS)

7.5 Session Control Statements (SCS)

7.6 Commands in SQL

7.7 Data Manipulation Language (DML) Statements

3. Specialty Databases and Applications

1. Introduction

2. Obstacles using Relational Data Model and Emergence of Special Databases

3. Object Oriented Databases (OODBMS)

3.1 Features

3.2 Advantages of OODBMS

3.3 ODL and OQL

3.4 OODBMS Vs RDBMS

3.5 OODBMS Vs ORDBMS

4. XML (Extensible Markup Language)

4.1 Structure of XML Data

4.2 XML Document Schema

4.3 Querying and Transformation

4.4    Application Program Interfaces to XML

4.5 Storage of XML Data

4.6 XML Applications

4. Transaction Processing and Concurrency

1. Concept of Transaction

2. Properties of Transaction

3. States of Transaction

4. Implementation of Atomicity and Durability

5.  Serializability and Testing for Serializability

5.1 Serializability

5.2 View Serializability

5.3 Testing for Serializability

5.4 Test for Conflict Serializability

5.5 Test for View Serializability

6. Concurrent Executions

6.1 Concurrency Control Techniques

6.2 Schedules and their Serializability

7. Concurrency control

7.1 Lock Based Protocols

7.2 Two-Phase Locking Protocol

7.3 Time-Stamps Based Protocol

7.4  Granularity of Data items

7.5 Deadlocking

7.6 Multiversion Techniques

5. Recovery Systems and Backup

1. Why Recovery is Needed?

2. Failure Classification

3. Recovery and Atomicity

3.1  Log Based Recovery

4. Recovery with Concurrent Transactions

5. Failure with Loss of Nonvolatile Storage

6. Recovery from Catastrophic Failure

7. Remote Backup Systems

6. NoSQL Database

1. Introduction

2. NoSQL Emerged From a Need

3. What is NoSQL

3.1 NoSQL Categories

3.2 Major NoSQL Players

4. How NoSQL Databases Differ From Each Other?

4.1 NoSQL Database Vs. RDBMS