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 |
which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?
Define "correlated subqueries".
What is correlated subquery in dbms?
What are types of dbms?
Define denormalization.
Explain Relational Algebra in RDBMS
What is maintaining database?
Why is database important?
Define checkpoint.
What are five types of database models?
What is the Result of the following 'VIK'||NULL||'RAM' ?
1 Answers HP, Manthan Solutions,
How can you CALL Reports from Forms4.0 ?