2006-10-11 10:33:52 · 7 answers · asked by bhardwaja t 1 in Computers & Internet ➔ Programming & Design
None of the above answers satisfied me. A DBMS(Database management System) is a software which allows storage, retrival, manipulation of data in a database. A RDBMS(Relational DBMS) adheres to Codd's rules. A relational model is concerned with three aspects,
Data Structure, Data intigrity and Data Manipulation and for that purpose it uses the rules of Relational algebra, Relational calculus. A plane DBMS can not support Data Intigrity. The topic is too vast to be explained here. Better read any one of the following books for a clear concept.
An Introduction to Database systems. By C.J.Date.
Or
An Introduction to Database systems By Bipin Desai.
Both r excellent books. Desai is more descriptive.
Date is brief, precise and interesting.
2006-10-12 08:29:52 · answer #1 · answered by binaryFusion 5 · 0⤊ 0⤋
In the world of data bases DBMS are the older generation and in today's world are almost extinct. What they are is basically a way to store data and manage it. RDBMS are the new version and are pretty much controlling the modern world of data base. RDBMS are build in order to normalize data. Normalized data is data that is organized in very restrictive way in order for the data to flow and link between itself. RDBMS contain feature like unique key fields for each record and data linking between tables. Data linking is being made under two constrains. A one to many relationship and many to many relationship.
2006-10-11 18:09:22 · answer #2 · answered by yairs2000 3 · 0⤊ 0⤋
RDBMS is a DBMS...
I mean there are many types of Data base management systems, but RDBMS is one its types..
The others include
Object oriented databases
Distributed Databases
And RDBMS, is most popular and widely used...
2006-10-11 18:09:07 · answer #3 · answered by krrish 2 · 0⤊ 1⤋
DBMS- Data Base Management System
RDBMS- Relational DataBase Management System
In DBMS u cant give a relation between two tables. You cant give that much constraint say primary key, foriegn key relationship.
For eg.
You have student table which contain coursecode also. You can bring a primary key, Foriegn key relationship that what are all the courses present in courses table only should be present in student table. This is possible only in RDBMS.
This is the main difference RELATING TABLES.
2006-10-13 13:46:16 · answer #4 · answered by Sudha P 2 · 0⤊ 0⤋
Hi friend, the DBMS is the field where we study or work on the data base but it is not sure that the data on which we are working is relational to each other means the different tables we are working with are having any common field in them. But when are studying or working with RDBMS, it is quite sure that all the data means the different tables are having at least one field common in them. Not sure for all tables but for relatively one for each two.
2006-10-11 18:37:57 · answer #5 · answered by bhagat3211 1 · 0⤊ 1⤋
'DBMS' means 'Database Management System'.
A DBMS is a management system for any type of database: realtional, network, object, flat file.
An RDBMS is a DBMS for relational databases.
2006-10-11 17:38:51 · answer #6 · answered by poorcocoboiboi 6 · 0⤊ 1⤋
DBMS is Data Base Management System
RDBMS is Relational data base management system.This is one of the type of DBMS.
2006-10-11 19:53:21 · answer #7 · answered by Aru 1 · 0⤊ 1⤋