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 Different Types of Joins and How do They Work?
What do you understand by join?
What is the use of COMPRESS option in EXP command ?
What is difference between database and file?
Why does reading require write privileges on database file?
What is data example?
Explain primary key and composite key.
How to retrive a single data from a database
When is a .FMB file extension is created in Forms 4.5 ?
What is foreign key in database?
What is a clustered database?