what is the difference between DBMS and RDBMS??
Answers were Sorted based on User's Feedback
Answer / dharshana
-Is a single user system.
-Does not support client server architecture.
-Normalization techniques cannot be applied.
-Memory allocation is less.
-Is a multi user system.
-Supports client server architecture.
-Normalization techniques cannot be applied for checking
the consistency of the database system.
-Memory allocation is huge.
|Is This Answer Correct ?||29 Yes||9 No|
Answer / vikas jaiswal
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
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.
Yes you can say 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.
|Is This Answer Correct ?||28 Yes||17 No|
Answer / mohnish chopra
In DBMS, data can be stored in any form i.e in form of
Whereas in RDBMS, DATA CAN BE STORED ONLY IN FORM OF TABLES
WHERE COLUMNS REPRESENTS ATTRIBUTES AND ROWS REPRESENTS
|Is This Answer Correct ?||11 Yes||0 No|
The main difference between DBMS and RDBMS is DBMS does not
impose any constraints or security with regard to data
manipulation it is user or the programmer responsibility to
ensure the ACID(Atomicity Consistency Isolation and
Durability) PROPERTY of the database whereas the rdbms is
more with this regard bcoz rdbms define the integrity
constraint for the purpose of holding ACID PROPERTY.
|Is This Answer Correct ?||10 Yes||0 No|
Answer / zubair ali
DBMS:1)In dbms no relationship concept
2)It supports Single User only
3)It treats Data as Files internally
4)It supports 3 rules of E.F.CODD out off 12 rules
5)It requires low Software and Hardware Requirements.
1)It is used to establish the relationship concept between
two database objects, i.e, tables
2)It supports multiple users
3)It treats data as Tables internally
4)It supports minimum 6 rules of E.F.CODD
5)It requires High software and hardware requirements.
|Is This Answer Correct ?||25 Yes||16 No|
Answer / akhilesh bisht
1.In DBMS the relation between two tables or files are
maintained by programming.Where as no need of programming
in RDBMS it relates dynamically.
2.Neither client-server support nor distributed database
support available in DBMS whereas both are available in
3.Follows >7 Codds rule in DBMS, whereas RDBMS follows >7 codds
4.Data is not secure in DBMS as compare to RDBMS.
|Is This Answer Correct ?||45 Yes||37 No|
Answer / chandrasekhar.patri
dbms is not providing securirty for data, where as rdbms
will provide it... and also normalization will not support
in dbms,where as rdbms will supports it..dbms will stores
flat data where as in rbbs realtions between data and tables
and entitys will provide................
|Is This Answer Correct ?||7 Yes||0 No|
Answer / jyothish
DBMS Doesnot follow the normalization concepts while RDBMS
follows the normalization concepts. This is the major
difference between them
|Is This Answer Correct ?||6 Yes||0 No|
Answer / divya
DBMS-Data Base Management Sysytem----No relation between
datas stored in databaseRDBMS-Relational Data Base
Management System-Relation between datas stored in
databaseDBMS 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".
|Is This Answer Correct ?||5 Yes||0 No|
Answer / keerthi krishna
DBMS id data base management system where the data is
stored a particular order while RDBMS is relational data
base management system where the data is stored based on
|Is This Answer Correct ?||4 Yes||0 No|
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
how to generate an auto incremental number in a ssis package?
Is this statement true or false? All databases must be in third normal form?
How do we select distinct values from a table?
What are some of the important security features of a dbms?
How to configure events with firewall?
What are its two major subsystems of r?
Tell me about view, sequence and index in DBMS.
What do you understand by ‘atomicity’ and ‘aggregation’?
What is data model example?
What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?
Explain the terms specialization and generalization.