DBMS (Database Management System)”

DBMS:

 A system whose overall purpose is to record and maintain information
 A database is a repository for stored data and programs to manipulate it.

Structure of DBMS:

Advantages of DBMS

 Centralized control.
 No Data Redundancy
 Data Consistency
 Data can be shared
 Standards can be enforced
 Security can be enforced
 Integrity can be maintained
 Data independence
Types of DBMS

 Hierarchical
 Network
 Relational
Hierarchical DBMS

Data is represented by a tree structure.

• Cannot handle Many-Many relations
• Can not reflect all real life situations
• Anomalies in insert, delete and update operations.


Network DBMS
• Data is represented by records and pointers
• Addresses Many-Many relations
• Insert, delete, update operations possible
• Complex in design
Relational Database
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the relational model.
Key-Points:
 Data is represented in terms of rows and columns of a table
 Addresses all types of relations
 Easy to design
 No anomalies for insert/delete/update