Database Management System

DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner. This tutorial explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure and much more.

Before you start proceeding with this tutorial, it is recommended that you have a good understanding of basic computer concepts such as primary memory, secondary memory, and data structures and algorithms.

• Overview
• Architecture
• Data Models
• Data Schemas
• Data Independence

• ER Model Basic Concepts
• ER Diagram Representation
• Generalization, Aggregation

• Codd's Rules
• Relational Data Model
• Relational Algebra
• ER to Relational Model
• SQL Overview

• Database Normalization 
• Database Joins

• Storage System
• File Structure

• Indexing
• Hashing

• Transaction 
• Concurrency Control 
• Deadlock

• Data Backup
• Data Recovery