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 |
How do you invoke datastage using unix?
What is the use of OWNER option in EXP command ?
What is meant by system analysis?
What is maintaining database?
What is an ALERT ?
What are ACID properties?
11 Answers Amazon, Cap Gemini,
Enlist various types of interactions created by dbms?
What is the difference between primary key and secondary key?
0 Answers Axtria, ITC Indian Tobacco Company,
What are its two major subsystems of r?
What do you mean by Checkbox ?
What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.
What do you mean by transparent dbms?