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


Please Help Members By Posting Answers For Below Questions

Where you have applied oops in automation framework?

652


How did you use automating testing tools in your job?

1536


what is GDC

1733


Explain me what are the main advantages of automation testing?

497


What is an automation testing framework?

575






Tell me what are the different types of navigation commands?

501


Tell me what is tsl? What 4gl is it similar too?

577


Do you know what is a xpath?

542


What is tree view in automation testing?

562


What is an automated test script?

666


what is dynamic window and dynamic model ? (worksoft automation tool)

1581


Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines

1434


Tell us which package can be imported while working with webdriver?

608


Do you know the difference between close and quit command?

494


Which package can be imported while working with webdriver?

813