Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff between dbms and rdbms(what are the 12
rilations in the rdbms).
- 5 Answers
- 8214 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ashumku7
1: In DBMS files are stored and retrieved through programs
whereas in RDBMS everything is stored in the form of table.
2: DBMS does not support client server architecture whereas
RDBMS does;
3: DBMS satisfy less than 7 to 8 rules of E.F codd where as
RDBMS satisfy more than 7 to 8 rules.
4: In DBMS there is no security of data where as in RDBMS
there are different(generally 3)layers of security:
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rajesh
dbms : Database management system
types of dbms: network,hierarchial,object-oriented,relational,object-relational
rdbms : relational database management system.
It is a type of dbms which is the most popular one.
data is arranged based on Entity-Relationship model
(E-R model) in rows and columns (records,attributes)
So, RDBMS and DBMS are not comparable because DBMS is a concept and RDBMS is a kind of DBMS.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sunil kumar
dbms is database management system that allow instance
delete insert update
rdbms is store related tablespace data and folw 12 rulls
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / 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 |
What is the use of PARFILE option in EXP command ?
How do you exit a database?
how to restore particular schema from rman full backup?
What are the Common SQL Functions Used for Data Aggregation?
What is a hierarchical database?
Explain the difference between dbms and rdbms?
PL/SQL supports which datatypes?
How do you copy a database?
What is a data type in a database?
Define b-trees.
What are 3 types of databases?
What do database languages do?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
