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
How to determine who is and change the owner of database?
How to find the size of database?
How to debug stored procedures?
What's the best database software for mac?
Explain the scenarios or situations under which progress database creates new index entry for a record?
What is the difference between indexes,views,synonyms?
What do you understand by aggregation and atomicity?
What is 2-tier architecture?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
Why normalisation is required?
What is trigger in dbms?
Explain what are service-specific middleware?
What is query in database?
What is the main purpose of a database?
Why do we need database normalization?