Difference between DBMS and RDBMS...CODD's rules

Answers were Sorted based on User's Feedback



Difference between DBMS and RDBMS...CODD's rules..

Answer / jyoti ranjan parida

DBMS-Database management system.
=>In dbms no relationship concept
=>It can't impliment constraints in table and no security
of data.
=>It supports Single User only
=>It treats Data as Files internally
=>It supports 3 rules of E.F.CODD out off 12 rules
=>It requires low Software and Hardware Requirements.
=>Examples:Foxpro
RDBMS-Relational management system
=>It is used to establish the relationship concept between
two database objects, i.e, tables
=>It impliment constraints in table and no security of data.
=>It supports multiple users
=>It treats data as Tables internally
=>It supports minimum 6 rules of E.F.CODD
=>It requires High software and hardware requirements.
=>examples:Oracle,mysql,DB2.

Is This Answer Correct ?    39 Yes 3 No

Difference between DBMS and RDBMS...CODD's rules..

Answer / avi007

DBMS-Database management system.
1> consider as file says field,attributes,record and file.
2> table relationship mentained by programmaticaly.
3> high network trafic.
4> distributed datable not supported.
5> no security

RDBMS-Relational management system
1> says column, row and table.
2>table relationship mentained at the time of table
creations.
3>low network trafic.
4>distributed database supported.
5>login level security.

Is This Answer Correct ?    10 Yes 3 No

Difference between DBMS and RDBMS...CODD's rules..

Answer / ram

it is correct answer

Is This Answer Correct ?    8 Yes 4 No

Difference between DBMS and RDBMS...CODD's rules..

Answer / achal sharma

it's correct.

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,


Is sql the best database?

0 Answers  


How do I order by ascending in sql?

0 Answers  


What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  


What is data manipulation language?

0 Answers  






Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  


What is the difference between nvl function, ifnull function, and isnull function?

0 Answers  


What is scope of pl sql developer in future?

0 Answers  


what are string data types? : Sql dba

0 Answers  


Explain exception handling in pl/sql?

0 Answers  


Its possible to add more than one primary key for the table

4 Answers  


Name some usages of database trigger?

0 Answers  


Categories