what is the diff between dbms and rdbms(what are the 12
rilations in the rdbms).
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 entity and its types?
Is it good to save image in database?
What is 3nf in dbms?
How view is related to data independence?
What is TERM ?
I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?
What do you mean by deadlock dbms?
Explain degree of a relation?
How many types of users in dbms?
what is storage manager?
Describe the differences between vertical and horizontal portioning.
What are the components of rdbms?
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)