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

Explain what is sql?

0 Answers  


I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  


how to select first 5 records from a table? : Sql dba

0 Answers  


what eliminate duplicate without using roenum and not

5 Answers   Matrix,


What is the command used to fetch the first 5 characters of a string?

0 Answers  






What is Referential Integrity?

3 Answers   IBM,


How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,


What is sql prepared statement?

0 Answers  


What is the criteria while applying index to any column on any table.

1 Answers   Infogain,


What is an exception in pl/sql?

0 Answers  


Does varchar need length?

0 Answers  


How do you optimize a stored procedure in sql?

0 Answers  


Categories