Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between DBMS and RDBMS??
- 76 Answers
- 199665 Views
- Aon Hewitt, BlackRock, Infosys, ISB, Jawood, TCS, I also Faced
- E-Mail Answers
Answer Posted / vmohan
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.
6)FoxPro, IMS are Examples
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.
6)SQL-Server, Oracle are examples
DBMS -->DATA BASE MANAGMENT SYSTEM
1-> dbms is collection of information
2->dbms does not support relational model
3->dbms does not support the security,
logshipping,replication
4->dbms use only small work area
5->
RDMS--> RELATIONAL DATA BASE MANAGNMENT SYSTEM
1->rdbms is collection of information and we can represent
a relation between two or multiple table
2->rdbms support security, replication , log shipping
3-> rdms use small and geographically area
example-- use for standby
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of normalization in dbms?
Define entity, entity type, and entity set.
How can you perform pattern matching in sql?
What is the difference between a shared lock and exclusive lock?
How to determine who is and change the owner of database?
How do I check my drivers?
Why is data modelling important?
What are types of dbms?
What is a foreign key constraint?
What do you mean by starvation in dbms?
What versions of clipper does netlib support?
what are the differences between network and hierarchical database model?
What is string in database?
Have you heard about sixth normal form?
What are new features postgre 9.1?
