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

Explain the advantages and disadvantages of a hierarchical database?

0 Answers  


Which software is best for database?

0 Answers  


What are the types of database explain each of them briefly?

0 Answers  


What do you understand by join?

0 Answers  


What are the features of rdbms?

0 Answers  






What is a distributed database system?

0 Answers  


What is rdbms table?

0 Answers  


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.)

2 Answers  


What are the advantages of database management system?

0 Answers  


Explain the term specialization.

0 Answers  


Describe the purposes and advantages stored procedure?

0 Answers  


What is computer end?

0 Answers  


Categories