what is the difference between DBMS and RDBMS??
Answers were Sorted based on User's Feedback
Answer / dharshana
DBMS:
-Is a single user system.
-Does not support client server architecture.
-Normalization techniques cannot be applied.
-Memory allocation is less.
RDBMS:
-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
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.
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.
Regards
Vikas Jaiswal
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
files,records,tables etc.
Whereas in RDBMS, DATA CAN BE STORED ONLY IN FORM OF TABLES
WHERE COLUMNS REPRESENTS ATTRIBUTES AND ROWS REPRESENTS
RECORDS..
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.
RDBMS:
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
RDBMS.
3.Follows >7 Codds rule in DBMS, whereas RDBMS follows >7 codds
rules.
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
the relationships
Is This Answer Correct ? | 4 Yes | 0 No |
For each user who needs access, the DBA creates an account in which database?
How can I join two tables in database?
What are the limitations of database?
In which format image is stored in database?
Why do we need database management?
What is the use of NOARCHIEVELOG parameter in Database?
What is flag in database?
What is 1nf?
How many columns are in a database table?
What is a logical backup ?
What do you mean by entity type?
Explain the advantages and disadvantages of a hierarchical database?