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 are the limitations of rdbms?

528


What is the diff bet plan,package,dbrm?

557


How do you copy a database?

492


What is data abstraction in dbms?

584


What's the best database software for mac?

478






What are the main differences between primary key and unique key?

499


Enlist some commands of dml?

529


How to select the first record in a given set of rows?

460


Mention the different languages present in dbms

509


What do you mean by buffer manager?

517


Discuss transparent DBMS?

750


What are the types of distributed database?

491


what are the two integrity rules used in DBMS?

623


What is database join?

481


Why is normalisation used?

485