Page 1 of 1

What is the difference between DBMS and RDMS?

Posted: Tue Jul 02, 2019 7:37 pm
by cascade
Whats the difference between DBMS and RDMS?

Re: What is the difference between DBMS and RDMS?

Posted: Tue Jul 02, 2019 7:43 pm
by Bob547
DBMS (Database Management System)
DBMS stands for Database Management System and treats data as files internally.
It defines the relationship between the files programmatically.
It does not impose any constraints or security with regard to data manipulation.
It does not support distributed architecture.
It does not support Client-Server architecture
Only one user can access data at a time
It satisfies maximum 6 to 7 rules of E.F. Codd (Edgar Frank "Ted" Codd) out of 12 rules.
Example- File System, XML, FoxPro, IMS


RDBMS (Relational Database Management System)
RDBMS stands for Relational Database Management System and treats data as relations means tables.
It defines the relationship between the relations called tables at the time of table creation.
It imposes constraints or security with regard to data manipulation.
It supports distributed architecture
It supports Client-Server Architecture
Multiple users can access the data at the same time
It satisfies more than 6 to 7 rules of E.F. Codd out of 12 rules.
Example – SQL Server, Oracle, DB2, MySQL