A Database is a collection of related data organized in a way that data can be easily accessed, managed and updated.

A DBMS is a software that allows creation, definition and manipulation of database. Dbms is actually a tool used to perform any kind of operation on data in database.

Please find the below attached file for the details of overview of Database Management System:

overview of Database Management System









Functions of DBMS

Provides data Independence
Concurrency Control
Provides Recovery services
Provides Utility services
Provides a clear and logical view of the process that manipulates data.

Database Concept consists of following:

Overview of DBMS
Database Architecture
Database Model
Codd's rule
RDBMS Concept
Database key
Normalization
E-R Diagrams
Generalization and Specialization

Advantages of DBMS

Segregation of applicaion program.
Minimal data duplicacy.
Easy retrieval of data.
Reduced development time and maintainance need.

Disadvantages of DBMS

Complexity
Costly
Large in size

Attached Files

overview of Database Management System.pdf (425.6 KB, 116 views)