what is the difference between DBMS and RDBMS??
Answers were Sorted based on User's Feedback
Answer / neeraj
DBMS
*****
DBMS are smaller organizations with small amount of
data,where security of data is not a major concern.
RDBMS
******
RDBMS are designed to take care of large amount of data and
also the security of data.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / priyank
1. In DBMS Normalization process will be not be present and in RDBMS normalization process will be present to check the database table consistency.
2. DBMS is a collection of programs which allows a user to create and maintain a database RDBMS is the reserve for DBMS .RDBMS helps in recovery of the database in case of loss of database due to system failure or any other reason.
3. DBMS, client server concept is not present. RDBMS, client server architecture is present
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anilbabu
1.dbms cannot support client/server arcchitecture where as
rdbms does
2.dbms doesnot support distriduted database where as rdbms does
3.there is no security of data in dbms where as rdbms does
4.each table is given an extension in dbms but in rdbmsthey
are grouped in one database
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / vinod s d
DBMS: 1.It does not support client server architecture. 2.
DBMS is 2 tier architecture. 3. DBMS is security less. 4.
Data will not be stored in the tabular format.
RDBMS: 1. It supports client server architecture. 2. RDBMS
is 3 tier architecture. 3. RDBMS is security more. 4. Data
will be stored in the tabular format.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chauhan rakesh botad
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
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / preethi
RDBMS:
used to maintain the relation among the table.
DBMS:
used to maintain the database.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gowtham raj
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
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / aiswarya
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
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mohd ikram
In DBMS relationship b/w two tables or files are maintained programmatically .
Where as in RDBMS relationship b/w two tables or files can be specified at the time of table creation.
Is This Answer Correct ? | 1 Yes | 0 No |
What are stored-procedures? And what are the advantages of using them.
how can we restore RMAN backup from SUN O/S to AIX 5.3? is it possible or not?
Explain why an information gap exists in most organizations.
Explain issues for database performance.
What are the types of database servers?
What is dbms architecture?
Is driver a software?
What is database schema in dbms?
How to find the size of database?
What is blob database?
Explain the term entity type in dbms?
What are the types of database lock?