Question { Stag Computers, 71776 }
What is the difference between RDBMS and DBMS?
Answer
The difference in RDBMS and DBMS does not lie in the way
tables and data are related to each other (ie. the Foreign
Key relationship). dBase and MS Access are DBMS's which
have foreign key relationships implemented.
RDBMS is based on the concepts of Relational Set Theory in
mathematics and hence the name Relational Database
Management System. They implement the project, restrict,
union, intersect, difference, product, divide and join in
the queries. DBMS's on the other hand, supports two or
more, but not all of the concepts.