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</br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br></br>