DATABASE MANAGEMENT SYSTEM

Notes,quiz,blog and videos of DBMS for computer science engineering,MCA,BCA.

Notes,quiz,blog and videos 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