GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Certification  >  Oracle  >  Oracle Developer
Go To First  |  Previous Question  |  Next Question 
 Oracle Developer  |  Question 13 of 23    Print  
What is the basic difference between DBMS and RDBMS ?

  
Total Answers and Comments: 14 Last Update: August 18, 2008     Asked by: skmishra_it 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
  Sorting Options  
  Page 1 of 2   « First    1    2    >     Last »  
February 20, 2006 02:55:05   #1  
innovative Member Since: February 2006   Contribution: 11    

RE: What is the basic difference between DBMS and RDBM...
in rdbms the data is maintained in the form of relations(table) and they are related to each other using primary key and foreign key concepts which is helpful in maintaining integrity of the data and to reduce redundancy.there is no pk fk concept in dbms.
 
Is this answer useful? Yes | No
February 22, 2006 01:52:15   #2  
alAli Akbar        

RE: What is the basic difference between DBMS and RDBM...

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


 
Is this answer useful? Yes | No
March 20, 2006 04:10:55   #3  
kavitha rangdhale Member Since: March 2006   Contribution: 2    

RE: What is the basic difference between DBMS and RDBM...

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


 
Is this answer useful? Yes | No
April 01, 2006 05:11:05   #4  
SHAMBHU KR JHA        

RE: What is the basic difference between DBMS and RDBM...
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.
 
Is this answer useful? Yes | No
April 15, 2006 02:04:19   #5  
prabha sharma        

RE: What is the basic difference between DBMS and RDBM...

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.


 
Is this answer useful? Yes | No
April 26, 2006 04:03:47   #6  
Sidhant        

RE: What is the basic difference between DBMS and RDBM...
 database has to be persistent, meaning that the information stored in a database has to continue to exist even after the application(s) that saved and manipulated the data have ceased to run. A database also has to provide some uniform methods that are not dependent on a specific application for accessing the information that is stored inside the database.

This is a pretty liberal definition of a database. Lotus Notes calls its message stores "databases", and by this definition they qualify. MUMPS calls its associative storage a database, and while it takes a bit of a stretch, even that meets this definition. There are a number of new database technologies that include object-oriented databases and associative databases, and they seem to qualify as databases under this definition too.

Text or flat binary files don't qualify as databases under this definition, since only the application that created one of these files knows enough about the file's contents to make use of the information stored within the file. They meet the persistence part of the DBMS definition, but not the independent access part of the definition.

Other "standards" like the Berkeley DB format supported by Perl, Python, and related languages do more or less qualify as a DBMS. While it isn't what most people think of when they think about DBMS setups, it does meet both the persistence and uniform access conditions for a DBMS.

An RDBMS is a Relational Data Base Management System. 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 I've listed so far since they either don't support a tabular structure at all, or don't enforce relationships between tables.

Microsoft's Jet database engine qualifies as an RDBMS under this definition, even though it seems like the majority of its users ignore the "relational" side of the engine by failing to declare foreign keys. Individual FoxPro files do not qualify because they don't have any built-in method for declaring or supporting relationships, even though nearly every FoxPro system I've ever seen expects or relies on these relationships.

Most DBAs think of an RDBMS as a client/server system. The database engine runs on a server, and client applications connect and request data from the server. Microsoft SQL Server, Oracle, DB2 (both the Z series and the UDB product), and most of the other "industrial grade" databases in use today use this mental model.

No discussion of RDBMS would be complete without mentioning "An Introduction to Database Systems" by Chris Date. This is the present incarnation of the book that originally defined the Relational Model as Edgar F. Codd defined it. You can read more at the Learning Zone.


 
Is this answer useful? Yes | No
June 05, 2006 14:03:54   #7  
Shital Supase        

RE: What is the basic difference between DBMS and RDBM...

            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

 


 
Is this answer useful? Yes | No
June 05, 2006 14:04:08   #8  
Shital Supase        

RE: What is the basic difference between DBMS and RDBM...

            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

 


 
Is this answer useful? Yes | No
June 05, 2006 14:04:23   #9  
Shital Supase        

RE: What is the basic difference between DBMS and RDBM...

            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 &

 


 
Is this answer useful? Yes | No
June 05, 2006 14:04:44   #10  
Shital Supase        

RE: What is the basic difference between DBMS and RDBM...

            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

 


 
Is this answer useful? Yes | No
  Page 1 of 2   « First    1    2    >     Last »  


 
Go To Top


 Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape