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.
