What is difference between DBMS and RDBMS ?

 

DBMS stands for database management system.

It allows to user to create store retrieve and manage data in a structured way.

Examples:

• Microsoft Access
• dBASE
• FoxPro
• File-based systems

 

RDMS  is stands for the relational database  management system.

 It is a database management system that store the data in the form of table(row and column)

 

Examples of RDBMS:

• MySQL
• Oracle Database
• Microsoft SQL Server
• PostgreSQL
• IBM Db2

DBMS vs RDBMS:

Feature	DBMS	RDBMS
Data storage	Data stored as files	Data stored in tables
Relationships	No relation between data	Relationships between  tables using keys
Normalization	Normalization is not enforced	Data is normalized to avoid redundancy
Data integrity	Low data integrity	High data integrity due to constraints
Query language	May not use SQL	Uses SQL as standard query language
Transactions (ACID)	Limited support to ACID	Full support to the ACID

 

In short:

• DBMS = simple data storage system
• RDBMS = advanced system with relationships, integrity, and SQL