What is the Difference between DBMS and RDBMS?

Thanks,thank you so much .

 

hello shabbir,
am not still clear with the concept can u explain about how the datas are stored in both dbms and rdbms

 

and i want to know one thing, in many web sites i read that the disadvantages of dbms as "it can store large data" but then y we should migrate from dbms to rdbms

 

hi shabbir,
thanks 4 ur reply.. i hav 1 mre doubt.. wats d reason to migrate from dbms to rdbms..
(in other words wats d problm with dbms)

 

Thank you very much keep the good work

 

DBMS : that is Data Base Management system
RDBMS : Relational DataBase Management System.

 

thanks for explaining about the differnce between dbms and rdbms...

 

DBMS stands for Database Management System which is a general term for a set of software dedicated to controlling the storage of data.
RDMBS stand for Relational DataBase Management System. This is the most common form of DBMS. Invented by E.F. Codd, the only way to view the data is as a set of tables.

The main advantage of an RDBMS is that it checks for referential integrity (relationship between related records using Foreign Keys). You can set the constraints in an RDMBS such that when a paricular record is changed, related records are updated/deleted automatically.

 

Hi Shabbir,
Thanks for sharing useful information.

 

dbms is the simple way of storing and retrieving the information, whereas in RDBMS entities r related to each other.there r some relations in the entities of the different table.

 

Hello sir,
Can you tell me if i want to be DBA. What software should i study, currently i am enjoying working with sql server 2005. Is it suff. or i should acquire some additional knowledge.

 

Plz tell......What is SQL(Admin)? IS it a book or a software. Which link or book should i follow to study this.

 

i HAVE NO BRIEF KNOWLEDGE ABOUT IT SO THANKS FOR SHARING INFORMATION.

 

Thanks for sharing this difference because this question is frequently asked in technical interview.It is helpful.

 

I found your information is very useful and correct.
Thanks

 

thankxxxx alot for this information.........

 

I completely agreed with Shabbir, infact I think this one is the best explanation.