2006-10-04 05:03:12 · 6 answers · asked by siva 1 in Computers & Internet ➔ Programming & Design
The "r" specifies that the database is a relational database (as opposed to flat, hierarchical, etc)
2006-10-04 05:04:50 · answer #1 · answered by IT Pro 6 · 0⤊ 0⤋
Dbms is database management systems and Rdbms is relational database management systems.Though both deal with handling data(which includes storing,deleting,retrieving,inserting and updating data) the difference is that in DBMS,the data however large ,is stored in a single table.Whereas in Rdbms the data that is to be stored is split appropriately into many tables under a common database name and these different tables dealing with the same type of data are related to each other by defining certain relations(so the name 'R'dbms i.e relational).
For example,consider the database to store student records.In DBMS,all details like name,roll,marks,street,city ,state,phone will be stored in a single table.But in Rdbms,the database is splitted something like the name,marks,roll under the 'student details' table and the street,city,state,phone under the 'Contacts' table.Any information to be obtained is done by the properly relating the 'student details' and 'contacts' tables.DBMS offers a very limited scope for data retrieval using queries when compared to Rdbms.Examples of Rdbms-Oracle,MS-Access.
2006-10-04 13:12:10 · answer #2 · answered by Kim 2 · 1⤊ 0⤋
DBMS-A database can be thought of as a set of logically related files organized to
facilitate access by one or more applications programs and to minimize
data redundancy. This concept does not imply that all data relating to a
company’s business should be contained on a single database, but simply
that all records in a database should be related and that redundant data should be minimized
RDBMS-A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model
2006-10-04 12:20:49 · answer #3 · answered by Sielent Worrier 3 · 0⤊ 0⤋
DBMS - Database Management Systems
RDBMS - Relational DBMS
RDBMS uses relations to connect more than one table.
2006-10-04 12:06:35 · answer #4 · answered by itguy 2 · 0⤊ 0⤋
Database Manager System vs. Relational Database Manager System, so the difference is the "Relational", however almost all database managers today are relational so actually there is no difference.
2006-10-04 12:06:35 · answer #5 · answered by johannsinuhe 2 · 0⤊ 0⤋
access method. example RDBMS are access
2006-10-04 12:05:52 · answer #6 · answered by arveen paria arasuk 6 · 0⤊ 0⤋