what is the difference between DBMS and RDBMS??
Answers were Sorted based on User's Feedback
Answer / irshad
* In DBMS relationship between two tables or files are
maintained programmatically butIn RDBMS relationship between
two tables or files can be specified at the time of table
creation.
*It does not support client/server architecture but Most of
RDBMS are support client/server architecture.
*DBMS does not support distributed databases but Most of
RDBMS are support distributed databases.
*In DBMS there are no tight security of data.butIn RDBMS
there are multiple levels security
1-Logging in at OS Level
2-Commands levels
3-Object levels
* Each table is given an extension in DBMS but Many tables
are grouped in one DB in RDBMS
*DBMS may satisfy less than 7 to 8 rules of Dr. E.F.
Codd.but RDBMS may satisfy more than 7 to 8 rules of Dr.
E.F. Codd.
| Is This Answer Correct ? | 62 Yes | 12 No |
Answer / pradeep kumar
1> DBMS
it Does not support client/server architecture
>it Does not support distributed Data base architecture.
> here no relationship concept.
> here no PK and FK concept.
> it is not show relationship between table.
>It supports Single User only
RDBMS
>it support client/server architecture
>it support distributed Data base architecture.
>it is based on relationship concept.
>it is show relationship between table.
> it is support PK and FK concept.
>It supports multiple users
| Is This Answer Correct ? | 53 Yes | 6 No |
Answer / sushil kumar
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
http://www.hotncr.blogspot.com
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
http://www.hotncr.blogspot.com
| Is This Answer Correct ? | 53 Yes | 14 No |
Answer / praveen saini
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 ? | 39 Yes | 8 No |
Answer / janma
DBMS:
# small organization with small amount of data.
# less memory.
# contains only flat data.
# no concept of primary key & foreign key.
# supports single user.
# can be saved in any order.
RDBMS:
# designed to take care of large amount of data.
# more memory.
# contains some relation between entities.
# includes primary key & foreign key.
# supports multiple user.
# should be sved in table format.
| Is This Answer Correct ? | 39 Yes | 8 No |
Answer / hema
In DBMS, has not Support Normalization Concept
But RDBMS is the Relational DBMS. So the concept of RDBMS
to be added as a 12 codd Rules. The Oracle has introduced
Codd.. So the Main Concept is Normalization Rules. After
that ACID Properties, etc.
| Is This Answer Correct ? | 51 Yes | 25 No |
Answer / rajesh singh
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
| Is This Answer Correct ? | 35 Yes | 9 No |
Answer / younus
ef.codd rule
>every dbms package need to support min 6rules to declare
it self as rdbms
1>high level INSERT DELETE UPDATE
2>data distribution
3>gaurenteed access
4>view updation
5>systematic treatment for NULL
6>physical and logical data independency
| Is This Answer Correct ? | 31 Yes | 6 No |
Answer / amarjit walake
DBMS stands for Database Managment System
RDBMS stands for Relational Database Manegment System
| Is This Answer Correct ? | 45 Yes | 21 No |
Answer / velmani
dbms it may be saved in any order.. while rdbms it should be
saved in table format..
| Is This Answer Correct ? | 48 Yes | 28 No |
What is a driver in programming?
What are the types of Calculated columns available ?
Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com
What you mean by Object Relational DBMS?
What is natural key?
What is database connection pool size?
Explain the Surrogate Key in DBMS.
What is CRUD Operations?
What is oracle block? Can two oracle blocks have the same address?
what is difference between paging and fragmentation?
What is the function of DML Compiler?
How do you backup a database?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)