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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sorting in dbms?

596


Define union all operator and union.

607


What is the purpose of a database?

628


Is google a database?

666


What is an extensible database?

543






Explain the syntax of named procedure?

631


What do you mean by DBMS?

637


What are some disadvantages of a standard language such as sql?

537


What are the elements of a database?

545


What is the instance of a relation?

582


Explain the terms database and dbms?

596


What is limit in dbms?

570


What is database optimization?

596


What are different types of transaction isolation levels?

576


Explain a database server?

695