DBMS & RDBMS Concepts

DBMS & RDBMS Concepts:-

Database management system (DBMS):-

Database management system is a program which uses standard method of cataloging, retrieving and modifying data. In DBMS, DML operation affects whole database.

Relational database management system (RDBMS):-

Relational database management system holds data in a table format. Structure of the RDBMS is table, fields and records. Tables further consist of rows and rows consist of table fields. You can perform DML operation to a particular table only which means unlike DBMS, DML operation affects the whole database but in RDBMS DML operations affects only to a particular table.

RDBMS stores data in tables which might be related to each other by common fields. Relation constitutes of primary key and foreign key constraint.