Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between DBMS and RDBMS??
- 76 Answers
- 202068 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 do you understand by data redundancy?
What is the best database management system?
Explain bcnf (boyce-codd normal form)?
What are the three types of databases?
What is a database in layman terms?
What do you understand by clause in sql?
what are the different integrity rules present in the dbms?
How many database systems are there?
What do you understand by correlated subqueries in dbms?
What is advantage of dbms?
What is the difference between horizontal and vertical partitioning?
How do you start a database?
Explain top-n analysis in DBMS.
What is a key in database?
How can we check whether A S M instance is up or down?
