Answer / mahesh mishra

1)DBMS permits only one person to access the database at a
given time.But RDBMS gives the multiple access the database
at a given time.
2)DBMS organised the data in any formmate but RDBMS allows
only in row and column format.
3)In DBMS we can not create the the relationshs but in
RDBMS we can not create the relationship between the tables

Answer / abdul waheed

its very simple,,,,there are three main differences b/w
RDBMS & DBMS

1- There is a condition in RDBMS that data should be stored
in tabular(only in Rows and column) Form/ In DBMS data can
be stored in any format

2- In RDBMS all the tables and the content of the tables
keeps relationship...thats y it called Relation DBMS///// in
DBMS column or table dont have any relationship

3- RDBMS can be accessed by multiple users at a same
time////////// DBMS can be accessed only by single user.


Oracle,SQl,DB2,and My Sql all these databases use RDBMS

Answer / vishal sharma

#1 A DBMS has to be persistent, that is it should be
accessible when the program created the data ceases to
exist or even the application that created the data
restarted. A DBMS also has to provide some uniform methods
independent of a specific application for accessing the
information that is stored.

RDBMS is a Relational Data Base Management System
Relational DBMS. This adds the additional condition that
the system supports a tabular structure for the data, with
enforced relationships between the tables. This excludes
the databases that don't support a tabular structure or
don't enforce relationships between tables.


#2 DBMS does not impose any constraints or security with
regard to data manipulation it is user or the programmer
responsibility to ensure the ACID PROPERTY of the database
whereas the rdbms is more with this regard bcz rdbms difine
the integrity constraint for the purpose of holding ACID
PROPERTY.

#3 DBMS are for smaller organizations with small amount of
data, where security of the data is not of major concern
and RDBMS are designed to take care of large amounts of
data and also the security of this data.

Answer / sree

DBMS or RDBMS are the different datebases models evolved
one after one.

Any file in this universe majorly falls into the following
categories
i) Data in a text file or other files
(.txt, .doc, .pdf, .ini etc.,)
ii) Data in a table format (.xls, .csv., etc)

In the first category the data is in a file and hence we
say it is not organised and no point of relation with other
files.

In the second category the data is in a table format which
contains colums and rows and hence we say it is in a well
organised manner. This kind of well organised data
representation is the base for all the Databases we use
these days.

Both DBMS and RDBMS are used to represent data in table
format, but it deffers how we represent and how we inter
connect, whats the data capacity, ease, application,
effeciency based on necessity etc.,

For example,
1) One Small Finance Company in a village has 500 customer
and 1000 transactions in an year. At the end of the year
the business owner want to see all the transactions to
analyse his business development. Here based on the
necessity and requirement the owner can use a excel or any
other spreadsheet model which is nothing but DBMS, just
managing database

2) A big insuracne company (Like LIC, Metlife) with huge
data like 1 crore customers (Includes customer address,
phone no., Email, ID, Policy Information etc.,), 2 Crore
claims, etc., Here the Company owner cannont use an excel
and hence the era of DBMS later lead to the invention of
RDBMS (Like Oracle, Teradata, DB2 etc.,) where the data
would not in a single table/excel sheet but in a different
tables with inter relationship.

What kind of relationship exists between tables?

As per example 2, let me take assume the business owner had
many tables among which the following are two tables
i) Customer_Details (This table is with details of customer)
ii) Customer_Claims (This table is with details of the
claims)

Customer_Details is a driving table for Customer_Claims as
the ID is the key which would be common between both the
tables. without id we cannot identify a claim of a
particular customer, this is called as relationship between
oth the tables.

Answer / rusabh tiwari

RDBMS IS RELATIONAL DATABASE MANAGEMENT SYSTEM IT MAINTAIN
A RELATION BETWEEN ENTITY .AND DBMS IS DATABASE MANAGEMENT
SYSTEM IT IS MAINTAIN A RELATION BETWEEN DATABASE

Answer / ajay

DBMS IS A GENERAL SOFTWARE SYSTEM FOR MANAGEMENT OF DATA.
WHERE AS RDBMD IS A SPECIFIC TYPE OF DBMS WHICH IS BASED ON
PRINCIPAL OF SET THEORY . RELATION WORD IN SET THEORY IS
DEFINED AS SUBSET OF THE CAETESIAN PRODUCT OF TWO OR MORE
SETS. DATA INTO A TABLE IS REPRESENTED IN FORM OF RELATION.
Apart from this E. F. Codd has prescribed 12 guideline for
DBMS to be a RDBMS WHICH IS KNOWK AS CODD'S RULE.

Answer / akhilesh

The difference in RDBMS and DBMS does not lie in the way
tables and data are related to each other (ie. the Foreign
Key relationship). dBase and MS Access are DBMS's which
have foreign key relationships implemented.

RDBMS is based on the concepts of Relational Set Theory in
mathematics and hence the name Relational Database
Management System. They implement the project, restrict,
union, intersect, difference, product, divide and join in
the queries. DBMS's on the other hand, supports two or
more, but not all of the concepts.

Answer / kalpana

Example of RDBMS is - ORACLE ,MY SQL..
Example of DBMS is - MSEXCEL

Answer / divya singh rajput

DBMS is collection of interrelated data and program to
access that data but RDBMS is collection of dbms for strong
security of data.

Answer / upasana

dbms is data base mgmt system....bt rdbms is relational
data base mgmt system

what happens if null values are involved in expressions? : Sql dba

0 Answers  

What is difference between nchar and nvarchar?

0 Answers  

What is a recursive stored procedure?

0 Answers  

Can a primary key be a foreign key?

0 Answers  

What are all ddl commands?

0 Answers  

what is a primary key? : Sql dba

0 Answers  

What is a cursor ? Why Cursor is required ?

3 Answers  

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

Show the cursor attributes of pl/sql.

0 Answers  

Where the Pre_defined_exceptions are stored ?

2 Answers  

Is primary key always clustered index?

0 Answers