diff b/w DBMS & RDBMS?

Answer Posted / alpesh

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.

In short, in RDBMS the normalization is there while in DBMS
no such normalization is there.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell us what you know about table-driven testing?

543


wat is database testing....how to develop data driven framework in selenium enviromnent. please explaing in detail

1620


What are the important operations in database testing?

538


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..

1422


What is a xpath?

561






If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.

1468


What is vendor tool and give examples?

601


In general, how do you see automation fitting into the overall process of testing?

1410


i have one answer from you that today the test cases are not stored in the database(SQL server 2005). But in automation testing where does the test case store? plz tell me... i have more confusion

1491


What type of scenarios can't be automated?

557


Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?

479


What is ‘good code’? What is ‘good design’?

543


What are the different types of scripting techniques for automation testing?

535


In what condition we cannot use automation testing for the agile method?

626


can any one tell me the examples of white box testing

1997