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
What are the two types of indexes and explain them in detail?
What are stand-alone procedures?
What is the concept of sub-query in terms of sql?
What is mean by dbms?
Mention the differences between unique key and primary key
Write a query to create a duplicate table with and without data present?
Which two statements are true about a foreign key?
What are the advantages of manual database?
What database does facebook use?
What is rdms?
Which database server is best?
What do you understand by functional dependency?
In DBMS, what are the two integrity rules used?
What is the purpose of using a model?
What is the difference between internal and external schema?