View Single Post
Old 15-03-06, 01:22 AM   #7 (permalink)
ajithcharles
Senior Member
 
ajithcharles's Avatar
 
Join Date: Mar 2006
Age: 24
Posts: 343
Thanks: 3
Thanked 12 Times in 12 Posts
Thanks: 3
Thanked 12 Times in 12 Posts
Rep Power: 8 ajithcharles will become famous soon enough ajithcharles will become famous soon enough ajithcharles will become famous soon enough
Okay this should answer ur questions




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. Because there can be relationships
between the tables, people often assume that is what the word
"relational" means. Not so. Codd was a mathematician and the word
"relational" is a mathematical term from the science of set theory. It
means, roughly, "based on tables".

------------

DBMS includes the theritical part that how datas are stored in a
table.It does not relates tables with another.
While RDBMS is the procedural way that includes SQL syntaxes for
relating tables with another and handling datas stored in tables.
---------------



A database has to be persistent, meaning that the information stored in
a database has to continue to exist even after the application(s) that
saved and manipulated the data have ceased to run. A database also has
to provide some uniform methods that are not dependent on a specific
application for accessing the information that is stored inside the
database.
An RDBMS is a Relational Data Base Management System. This adds
the additional condition that the system supports a tabular structure
for the data, with enforced relationships between the table
--------------------




the difference is dbms has no tables



while rdbms has and also it describes



about the relationships among the tables



dbms for small organisatiions



where rdbms for large amonut of data


--------------------------------

In DBMS all the tables are treated as different entities. There is no
relation established among these entities.
But the tables in RDBMS are dependent and the user can establish
various integrity constraints on these tables so that the ultimate data
used by the user remains correct.

-----------------------------------



ajithcharles is offline   Reply With Quote