what is the diff between dbms and rdbms(what are the 12
rilations in the rdbms).

Answers were Sorted based on User's Feedback



what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms)...

Answer / sid

DBMS is a system that allows to insert, update, delete and
retrieve data

RDBMS stores data in the form of related tables. It allows
data security

12 rules for RDBMS are:
-data should be tabular
-accessing of data must be easy
-supports for null values in fields other than primary key
-tool must be same for database structure and for data itself
-database must support at least one programming language
-data can be represented as views
-insert,update and delete operations for multiple tables/rows
-data should be physically independent
-data must be logically independent
-integrity independence of database
-user should not know distribution of database
-modifying database structure must be through a language
like SQL

Is This Answer Correct ?    6 Yes 1 No

what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms)...

Answer / ashumku7

1: In DBMS files are stored and retrieved through programs
whereas in RDBMS everything is stored in the form of table.

2: DBMS does not support client server architecture whereas
RDBMS does;

3: DBMS satisfy less than 7 to 8 rules of E.F codd where as
RDBMS satisfy more than 7 to 8 rules.

4: In DBMS there is no security of data where as in RDBMS
there are different(generally 3)layers of security:

Is This Answer Correct ?    3 Yes 0 No

what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms)...

Answer / rajesh

dbms : Database management system

types of dbms: network,hierarchial,object-oriented,relational,object-relational

rdbms : relational database management system.
It is a type of dbms which is the most popular one.
data is arranged based on Entity-Relationship model
(E-R model) in rows and columns (records,attributes)

So, RDBMS and DBMS are not comparable because DBMS is a concept and RDBMS is a kind of DBMS.

Is This Answer Correct ?    2 Yes 1 No

what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms)...

Answer / sunil kumar

dbms is database management system that allow instance
delete insert update
rdbms is store related tablespace data and folw 12 rulls

Is This Answer Correct ?    0 Yes 2 No

what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms)...

Answer / vikas gupta

dbms: is database management system
rdbms: it is the relational database management system.

12 rules for RDBMS are:
-data should be tabular or in normalized format
-accessing of data must be easy
-supports for null values in fields other than primary key
-tool must be same for database structure and for data
itself
-database must support at least one programming language
(SQL)
-data can be represented as views
-insert,update and delete operations for multiple
tables/rows
-data should be physically independent
-data must be logically independent
-integrity independence of database
-user should not know distribution of database
-modifying database structure must be through a language
like SQL

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Database Management Interview Questions

which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?

2 Answers  


Define "correlated subqueries".

0 Answers  


What is correlated subquery in dbms?

0 Answers  


What are types of dbms?

0 Answers  


Define denormalization.

0 Answers  






Explain Relational Algebra in RDBMS

0 Answers   Infosys,


What is maintaining database?

0 Answers  


Why is database important?

0 Answers  


Define checkpoint.

0 Answers  


What are five types of database models?

0 Answers  


What is the Result of the following 'VIK'||NULL||'RAM' ?

1 Answers   HP, Manthan Solutions,


How can you CALL Reports from Forms4.0 ?

1 Answers  


Categories