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 is denormalization and why would someone consider doing so?
Operators used in select statements are?
Who invented schema theory?
describe and contrast a trigger and a procedure.
What are the advantages of database?
How many rows can a database hold?
What is the main purpose of triggers in database?
What are the components of rdbms?
What do you understand by ‘atomicity’ and ‘aggregation’?
Explain why an information gap exists in most organizations.
What's the difference between star and snow flake schema?
How can you get data from a database in an Excel sheet?
What you know in mapping of erd to dfd?
What are five types of database models?
What is dbms_output put_line?