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 data types in database?
What are different types of data models?
Explain about the case statement present in stored procedure?
Explain by listing some of dbms major advantages.
Describe the difference between data and database administration.
Which is the most used database?
Explain what are triggers and rules?
What are the Roles and responsibilities of database administrator?
What are the benefits of database management system?
How data are stored in database?
What are the elements of a database?
Which two can be implemented as a centrally located logical architecture?
What is a driver in programming?
What is user and end user?
What is data model and types?