DBMS:1)In dbms no relationship concept
2)It supports Single User only
3)It treats Data as Files internally
4)It supports 3 rules of E.F.CODD out off 12 rules
5)It requires low Software and Hardware Requirements.
6)FoxPro, IMS are Examples
RDBMS:
1)It is used to establish the relationship concept between two database objects, i.e, tables
2)It supports multiple users
3)It treats data as Tables internally
4)It supports minimum 6 rules of E.F.CODD
5)It requires High software and hardware requirements.
6)SQL-Server, Oracle are examples
http://www.allinterview.com/showanswers/56803.html
A DBMS has to be persistent, that is it should be accessible when the
program created the data ceases to exist or even the application that
created the data restarted. A DBMS also has to provide some uniform
methods independent of a specific application for accessing the
information that is stored.
RDBMS is a Relational Data Base Management System
Relational DBMS. This adds the additional condition that the system
supports a tabular structure for the data, with enforced relationships
between the tables. This excludes the databases that don't support a
tabular structure or don't enforce relationships between tables.
Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.
Yes you can say DBMS does not impose any constraints or security with regard to data manipulation it is user
or the programmer responsibility to ensure the ACID PROPERTY of the
database whereas the rdbms is more with this regard bcz rdbms difine
the integrity constraint for the purpose of holding ACID PROPERTY.