diff b/w DBMS & RDBMS?
Answer Posted / siju george
huh:
Lots of differences ! nah.simple logics thats it... let get
going.May be someone correct me if going wrong ... :)
theres some rules and regulations for how to store and
maintain data(using algebric algorithm) and they are
written in a genuine way and became famous and are called
Codd Rules(12 or may be more.....).So if we know these
rules then its very easy to differentiate between DBMS and
RDBMS
1. Any database which adheres to minimum of 5-6 codd rules
are automatically called as RDBMS. for e.g oracle,SQL,etc
2. Both help to store persistent data however DBMS stores
them in a denormalized way in rows and columns where as in
RDBMS stores them in tabular cells and there is chance to
split data(normalise) and store them in separate tables.
3. Most important is the 'R' letter which separates them in
terms of relationship management.RDBMS enforces
referrential Integrity and thus maintain the relationship
and in a way gives security of data(no accidental
loss/addition of data).
4. Security in RDBMS is provided in terms of
constraints/rules/sp/triggers/locks etc which ensures
i.Domain Intigrity(Primary Key,Unique key,Identity column)
ii. Entity Intigrity(Default,Foriegn Key,Not null,Check)
iii.Referential Intigrity(Foriegn key,Check) and
iv. User Defined Integrity(SP/Triggers/Rules)
5. RDBMS follows ACID(Automicity,Consistency,Isolation and
Durability) rule where as DBMS doesnt follows them.
| Is This Answer Correct ? | 41 Yes | 9 No |
Post New Answer View All Answers
What is difference between selenium and QTP tools Which is best tool... Which is most used tool
Where you have applied oops in automation framework?
Where do we get the QTP and Load runner softwares CDs ( Original ) in chennai
Name some of the commonly used automation testing tools that are used for non-functional automation.
Name some of the commonly used automation testing tools that are used for functional automation.
Tell me what criteria do you consider for automating a test?
In general, how do you see automation fitting into the overall process of testing?
How to decide the tool that one should use for automation testing in their projects?
Tell us what methods of robot class do you know?
Explain me what kinds of annotations are used in testng?
Give some examples of priority – severity defect levels.
List out some of the automation tools which could be integrated with selenium to achieve continuous testing.
WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
What u mean by infrgistics control (What is infrgistics Controls)?
What are the pre-requisites to start automation testing?