No DBMS RDBMS
1) DBMS applications store data RDBMS applications store data in a tabular
as file. form.
2) In DBMS, data is generally In RDBMS, the tables have an identifier called
stored in either a hierarchical primary key and the data values are stored in
form or a navigational form. the form of tables.
3) Normalization is not present Normalization is present in RDBMS.
in DBMS.
4) DBMS does not apply any RDBMS defines the integrity constraint for
security with regards to data the purpose of ACID (Atomocity, Consistency,
manipulation. Isolation and Durability) property.
5) DBMS uses file system to store in RDBMS, data values are stored in the form of
data, so there will be no tables, so a relationship between these data
relation between the tables. values will be stored in the form of a table as
well.
6) DBMS has to provide some RDBMS system supports a tabular structure of
uniform methods to access the the data and a relationship between them to
stored information. access the stored information.
7) DBMS does not support RDBMS supports distributed database.
distributed database.
8) DBMS is meant to be for small RDBMS is designed to handle large amount of
organization and deal with data. it supports multiple users.
small data. it supports single
user.
9) Examples of DBMS are file Example of RDBMS are mysql, postgre, sql
systems, xml etc. server, oracle etc.