TOP CATEGORIES

×

What is the difference between DBMS and RDBMS?

P

Pratima S

DBMS [Database Management System]

  • DBMS stands for the "Database Management System"; it is a software used to store and manage data.
  • DBMS is used for the storage of data and efficient retrieval of data like insertion, deletion, and updating of the data.
  • DBMS has to provide some uniform methods independent of a specific application for accessing the information that is stored.
  • The data is generally stored in either a hierarchical form or a navigational form in DBMS.
  • Normalization is not present in the Database Management System.
  • DBMS does not support a distributed database.

RDBMS [Relational Database Management System]

  • RDBMS stands for the "Relational Database Management System" in SQL.
  • RDBMSes are a subset of DBMSes.
  • It is "relational" because the values within each table are related to each other.
  • The tables have an identifier called the primary key and the data values are stored in the form of tables in RDBMS.
  • Normalization is not present in RDBMS.
  • DBMS supports a distributed database.

0 votes

Your Answer

Related Topics