What is the difference between DBMS and RDBMS ?

Difference between DBMS and RDBMS:

DBMS:

 Data Base Management System is a process of managing data for efficient retrivel & storage of data.
        Ex: sysbase , Foxpro

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:

 The database which is used by relations(tables) to acquire information retrival are known as RDBMS
         EX: SQL, ORACLE,MY-SQLSERVER

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


RDBMS is the specific type, which follows the concepts of  set theory i.e entity etc. In DBMS there is no concept of  PRIMARY KEY and FOREIGN KEY but it is included in RDBMS.

DBMS contains only flat data whereas in RDBMS there will be  some relation between the entities.


0 comments:

Post a Comment