diff b/w DBMS & RDBMS?




Answers were Sorted based on User's Feedback



diff b/w DBMS & RDBMS?..

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

diff b/w DBMS & RDBMS?..

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

diff b/w DBMS & RDBMS?..

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




diff b/w DBMS & RDBMS?..

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

diff b/w DBMS & RDBMS?..

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

diff b/w DBMS & RDBMS?..

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

diff b/w DBMS & RDBMS?..

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

diff b/w DBMS & RDBMS?..

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

diff b/w DBMS & RDBMS?..

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

diff b/w DBMS & RDBMS?..

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

Post New Answer



More Automation Testing AllOther Interview Questions

Stop automating the tests which run once?

0 Answers  


How to Rcognize the Objects in the Web Page Dialog Using QTP

0 Answers  


what are the Extension files in QTP?

3 Answers  


If a scenario is given and asked whether we can automate the system according to that scenario,how wil we answer such type of questions?

1 Answers   TCS,


Hi vishal, Thanks for your reply... But i am not using Mozilla fire fox.. I am using IE 7.. Could you suggest me in this case.. I have tried with Rational tools which i am getting some installation problem and netvantage..tool....which i felt i can't write script for that.. please guide me in this..

0 Answers  






What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain

0 Answers  


can you ple give me Quality Center interview questions and answer

5 Answers  


what is the for identifying color of the object

2 Answers  


which is the best online training website?

0 Answers  


Manually in a page 10 check boxes is there.so 5 check box "on" and 5 check box "off" so using descriptive program how to know how many "on" and how many "off" plz help me this question answer?

0 Answers   IBM,


Which institute is good for testing tools course in HYD?

0 Answers  


Any one suggest me for Free ware (Opensource) Automation tool for regression testing.

0 Answers  






Categories