DATABASE MANAGEMENT SYSTEM

Description of DATABASE MANAGEMENT SYSTEM

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