DBMS vs RDBMS

DBMS:

  1. DBMS is the software program that is used to manage all the database that are stored on the network or system hard disk.
  2. DBMS does not impose any constraints or security with regard to data manipulation.
  3. It is user or the programmer responsibility to ensure the ACID PROPERTY of the database.
  4. In DBMS Normalization process will not be present.
  5. In dbms no relationship concept.
  6. It supports Single User only.
  7. It supports 3 rules of E.F.CODD out off 12 rules

RDBMS:

  1. RDBMS is the database system in which the relationship among different tables are maintained.
  2. RDBMS defines the integrity constraint for the purpose of holding ACID PROPERTY.
  3. In RDBMS, normalization process will be present to check the database table cosistency
  4. RDBMS helps in recovery of the database in case of loss of data
  5. It is used to establish the relationship concept between two database objects, i.e, tables
  6. It supports multiple users
  7. It supports minimum 6 rules of E.F.CODD.