Everyone

Arvind Kumar

Jelly Bean

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

DATABASE MANAGEMENT SYSTEM

DATABASE MANAGEMENT SYSTEM ၏ ေနာက္ဆုံးဗားရွင္း

အျခား ဗားရွင္းမ်ား