DATABASE MANAGEMENT SYSTEM

Simple notes of DBMS for computer science engineering,MCA,BCA. it almost cover all important topics which are given below

Unit 1 Basic Concepts

DBMS Concepts and architecture Introduction
Database approach v/s Traditional tile accessing approach
Advantages of database systems
Data models
Schemas and instances
Data independence
Entities and attributes
ER Diagram Representation

Unit 2 Data models and Relational Databases

Various data models
Database Model
Relational Data models
Characteristics of relations, Keys

Unit 3 Structured Query Language

Relational algebra and relational calculus
Relational algebra operations
Data definition in SQL
Update statements and views in SQL
Data retrieval queries and update statements

Unit 4 Database Design

Data Base Design
DBMS - Normalization
Functional Dependency

Unit 5 Advance Concepts

Introduction to Distributed databases
Security and integrity constraints
Concurrent operation on databases
DBMS - Transaction
Basic concepts of object oriented data base system and design