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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a checkpoint and When does it occur in database?

690


What are different relationships existing in database?

506


How to find the size of database?

573


Why is the use of dbms recommended? Explain by listing some of its major advantages.

1251


What is executive plan?

510






What are codd rules?

540


Why are recursive relationships are bad? How do you resolve them?

591


What is ims software environment?

520


Enlist the cursor types.

623


Explain the difference between physical and logical data independence?

501


What are the benefits of modeling?

498


What is query in database?

506


How to activate all indexes in firebird?

527


What do you mean by Checkbox ?

1938


How do convert or display the date or time as string?

632