Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between DBMS and RDBMS??
- 76 Answers
- 202495 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 compound key?
Is sql is a dbms?
What are the ways to controlling cursor behavior?
Who has the largest database?
What is bcnf in the dbms?
What is the meaning of flat file database?
How do you start a database?
Mention some disadvantages of query?
What is father dbms?
for what purpose we use MDM(master data management)tell me plz.
What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?
What is a candidate key in a database?
What is data sublanguage?
How do you rename a database?
What are database functions?
