diff b/w DBMS & RDBMS?
- 69 Answers
- 136187 Views
- BirlaSoft, Infosys, Mind Tree, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
in both dbms & rdbms the data is stored in the form of
rows and columns.
but the main difference between the dbms and rdbms
is we can establish the relation between the tables in
rdbms.in case of dbms we cannot establish relation between
tables.
| Is This Answer Correct ? | 533 Yes | 62 No |
Answer / ranjit
another difference between dbms and rdbms is that RDBMS
follows relational data model where as dbms can follow even
network, hierarchical or other data model.
| Is This Answer Correct ? | 248 Yes | 49 No |
Answer / keerthana
· 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.
| Is This Answer Correct ? | 152 Yes | 12 No |
Answer / venkat
DBMS(data base management systems) and RDBMS( relational
database management system) the main difference in dbms
data is stored in the form of rows and columns and in the
case of rdbms data stored in the form of tables and data
stored in dbms is temporarly where as in rdbms is
permanently
eg: dbms-->sysbase foxpro
eg: rdms-->oracle,sql server
| Is This Answer Correct ? | 313 Yes | 217 No |
Answer / shiva rama krishna
DBMS is used to store small amount of data where the
security is not a major concern.but RDBMS is used to store
large amount of data where security plays an important role.
examples of DBMS : Foxpro
examples of RDBMS : Oracle,sqlserver
| Is This Answer Correct ? | 138 Yes | 52 No |
Answer / satvir kaur
1.DBMS is DATA BASE MANAGEMENT SYSTEM
RDBMS is RELATIONAL DATABASE MANAGEMENT SYSTEM
2.In DBMS keys are not used.
In RDBMS keys are used.
3.In DBMS duplication of rows ans columns.
But in RDBMS there is no duplication of rows and columns.
4.In DBMS rows and columns are independent.
But in RDBMS rows and columns are dependent.
5.DBMS is for single user only.
RDBMS is for multi-user.
6.DBMS does not satisfies codd's rules.
RDBMS satisfies codd's rules
| Is This Answer Correct ? | 65 Yes | 9 No |
Answer / vishak
Short for relational database management system and
pronounced as separate letters, a type of database
management system (DBMS) that stores data in the form of
related tables. Relational databases are powerful because
they require few assumptions about how data is related or
how it will be extracted from the database. As a result, the
same database can be viewed in many different ways.
An important feature of relational systems is that a single
database can be spread across several tables. This differs
from flat-file databases, in which each database is
self-contained in a single table.
Almost all full-scale database systems are RDBMS's. Small
database systems, however, use other designs that provide
less flexibility in posing queries.
| Is This Answer Correct ? | 84 Yes | 33 No |
Answer / arindam mukherjee
There are basically two differences: -
1) The main difference between DBMS and RDBMS is that,
RDBMS follows the relational data model(given by Ted Codd
in 1970 in his research paper), which is based on the Set-
theorical concept of the mathematics.
Where as DBMS does not follow any specific data model.
2) In RDBMS we can establish logical relation between two
or more tables and by making such relations we can maintain
the integrity of the database (referential integrity), i.e
we can't insert data into the child relation if the data
does not exist in the parent relation.
Where as DBMS does not give us such facility and to
implement such things in DBMS, we have to use some other
application program.
| Is This Answer Correct ? | 44 Yes | 9 No |
Answer / siju george
huh:
Lots of differences ! nah.simple logics thats it... let get
going.May be someone correct me if going wrong ... :)
theres some rules and regulations for how to store and
maintain data(using algebric algorithm) and they are
written in a genuine way and became famous and are called
Codd Rules(12 or may be more.....).So if we know these
rules then its very easy to differentiate between DBMS and
RDBMS
1. Any database which adheres to minimum of 5-6 codd rules
are automatically called as RDBMS. for e.g oracle,SQL,etc
2. Both help to store persistent data however DBMS stores
them in a denormalized way in rows and columns where as in
RDBMS stores them in tabular cells and there is chance to
split data(normalise) and store them in separate tables.
3. Most important is the 'R' letter which separates them in
terms of relationship management.RDBMS enforces
referrential Integrity and thus maintain the relationship
and in a way gives security of data(no accidental
loss/addition of data).
4. Security in RDBMS is provided in terms of
constraints/rules/sp/triggers/locks etc which ensures
i.Domain Intigrity(Primary Key,Unique key,Identity column)
ii. Entity Intigrity(Default,Foriegn Key,Not null,Check)
iii.Referential Intigrity(Foriegn key,Check) and
iv. User Defined Integrity(SP/Triggers/Rules)
5. RDBMS follows ACID(Automicity,Consistency,Isolation and
Durability) rule where as DBMS doesnt follows them.
| Is This Answer Correct ? | 41 Yes | 9 No |
Answer / gyanendra singh
In RDBMS data stores in row and coloumn in a table.u can
maintain a relation between to table. But in DBMS data not
stors in row and colums and u can't maintain relation
between table.
perfect difference is that.... RDBMS follow the CODD's rule.
while DBMS not follow the CODD's rule.
| Is This Answer Correct ? | 81 Yes | 58 No |
When will you automate a test?
What type of scenarios can be automated?
Tell us how do you get the width of the textbox?
What are the advantages of the automation framework?
Tell us how could you explain the main difference between webdriver and rc?
What are the main attributes of test automation?
I want a code for a following item in TSL Language. Look up a person in database, If not found, add person to the database.
Tell me what type of scenarios can be automated?
what is the framework your fallowing in your organization while using automation tool ?
What are the important operations in database testing?
What is build verification testing, bvt?
how can we exactly identity whether that is manual or automation testing? and give any ex script
WinRunner 
