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
What is a checkpoint and When does it occur in database?
What are different relationships existing in database?
How to find the size of database?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
What is executive plan?
What are codd rules?
Why are recursive relationships are bad? How do you resolve them?
What is ims software environment?
Enlist the cursor types.
Explain the difference between physical and logical data independence?
What are the benefits of modeling?
What is query in database?
How to activate all indexes in firebird?
What do you mean by Checkbox ?
How do convert or display the date or time as string?