What is the difference between DBMS and RDBMS ?

Questions by skmishra_it

Editorial / Best Answer

RicGupta1984  

  • Member Since Sep-2007 | Mar 5th, 2008


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.

Showing Answers 1 - 7 of 7 Answers

alAli Akbar

  • Feb 22nd, 2006
 

DBMS is a software taht controls the organization ,retreival , storage, integrity ,secturity of data in DB

the basic difference between them is that in RDBMS we use Relationship B/w tables and nothing else

  Was this answer useful?  Yes

The difference in RDBMS and DBMS does not lie in the way tables and data are related to each other (ie. the Foreign Key relationship). dBase and MS Access are DBMS's which have foreign key relationships implemented.

RDBMS is based on the concepts of Relational Set Theory in mathematics and hence the name Relational Database Management System. They implement the project, restrict, union, intersect, difference, product, divide and join in the queries. DBMS's on the other hand, supports two or more, but not all of the concepts.

 - Shanim

SHAMBHU KR JHA

  • Apr 1st, 2006
 

DBMS IS A GENERAL SOFTWARE SYSTEM FOR MANAGEMENT OF DATA. WHERE AS RDBMD IS A SPECIFIC TYPE OF DBMS WHICH IS BASED ON PRINCIPAL OF SET THEORY . RELATION WORD IN SET THEORY IS DEFINED AS SUBSET OF THE CAETESIAN PRODUCT OF TWO OR MORE SETS. DATA INTO A TABLE IS REPRESENTED IN FORM OF RELATION. Apart from this E. F. Codd has prescribed 12 guideline for DBMS to be a RDBMS WHICH IS KNOWK AS CODD'S RULE.

prabha sharma

  • Apr 15th, 2006
 

Both DBMS and RDBMS are management system, used to manage database. Basic difference between them is that in case of RDBMS we can create permanent relationship between tables on the basis of primary key and foreign key and it satifies all the codd rules.

  Was this answer useful?  Yes

Shital Supase

  • Jun 5th, 2006
 

The basic difference between the DBMS & RDBMS is in DBMS u can only have flat data files in among which u will an/or can't have a realtionship. But in RDBMS the relationship can be maintained among the number of table or realtions within the

  Was this answer useful?  Yes

chinnadurai

  • Jan 16th, 2007
 

The Basic difference between DBMS and RDBMS. both are database management system.main difference is RDBMS having relationship between tables due to primarykey and foriegnkey. but in DBMS have no relationship.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

DBMS doesnt contain Primary keys and Foreign key constraints. It is something like Files in a programming language and like MS Access database. But where RDBMS maintains data in table consists of foreign key and primary key constraints. It reduces the redundancy and retrieval of data is far more easier in RDBMS.  RDBMS features are far more better and easier than DBMS.

  Was this answer useful?  Yes

mrjhajee

  • Nov 29th, 2008
 

1. DBMS depend on microsoft software like ms access, excel, dBASE1, While RDBMS is depend on ORACLE based programig language.

2. DBNS Stand  for  Data Base Management System While  RDBMS stand  for  Relational  DBMS.

  Was this answer useful?  Yes

supritha1

  • Dec 17th, 2008
 

DBMS is a set of program that controls the organizationn storage, management and retrival of data in a database.

RDBMS is a relational database management syatem is database management system based on the relational model.

  Was this answer useful?  Yes

mdtolia

  • Nov 14th, 2009
 


1. DBMS is a single user system RDBMS is a multiuser system
2. DBMS stores do not store data in the form of tables while RDBMS stores it in the form of tables.
3. Most of DBMS are not supporting client/server architecture as it is supported by RDBMS.
4. Most DBMS do not support distributed databases

5. DBMS does not support Codd rules more than 5/6 rules. RDBMS like SQL Server, MySQL RDBMS support more than 7 Codd rules


  Was this answer useful?  Yes

jacme

  • Nov 26th, 2009
 

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 RDBMS is more with this regard bcz rdbms define the integrity constraint for the purpose of holding ACID PROPERTY.

  Was this answer useful?  Yes

DBMS and RDBMS both are the management system instead in
case of RDBMS we use foreign keys, primary keys etc. which
is not possible in case of DBMS

  Was this answer useful?  Yes

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 define the integrity constraint for the purpose of holding ACID PROPERTY.

I have found many answers on many websites saying that

DBMS are for smaller organizations with small amount of data, where security of the data is not of major concern and RDBMS are designed to take care of large amounts of data and also the security of this data.
and this is completely wrong by definition of RDBMS and DBMS

  Was this answer useful?  Yes

asif shaikh

  • Nov 22nd, 2014
 

and other major difference are dbms does not support constraints and normalization.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions