Difference Between DBMS and RDBMS

Database:-

A database can be defined as a collection of data.

DataBaseManagementSystem:

Managing of data in the database is nothing but database management system(DBMS).

DBMS examples: Oracle, Ingress, Daaflex and so on.

Benefits of DBMS:

•  Data Redundancy
• no more data inconsistencies
• stored data can be shared by a single or multiple users
• standards can be set and followed
• data integrity
• security of data
• data independence can be achieved.

Before going to RDBMS we have to know few things about Dr. Edgar F.Codd.

Dr. Codd is an IBM researcher who first developed the relational data model in 1970.In 1985, Dr Codd published a list of 12 rules  that define an ideal relational database and has provided a guideline for the design of all relational database systems.

1. The Information Rule
2. Guaranteed Access Rule
3. Systematic Treatment of NULL values
4. Dynamic On-line Catalog based on the Relational model. 
5. Comprehensive Data Sublanguage Rule
6. View Updating Rule
7. High-level Insert,Update and Delete
8. Physical Data Independence
9. Logical Data Independence
10. Integrity Independence
11. Distribution Independence
12. Non subversion Rule

Relational Database Management System(RDBMS)

 RDBMS is a database management system that is based on the relational model as introduced by Dr. Codd.If any DBMS  follows at least 6 rules then that is know as RDBMS.

Relational Database Management System stores data in the form of related tables.RDBMS are powerful because they require few assumptions about how data is related or how it will be extracted from the database.
An important feature of relational systems is  that a single database can be spread across several tables.
Popular commercial RDBMS for large databases include Oracle, Microsoft SQL server, IBM's DB2 and so on.

Difference between DBMS and RDBMS

• In DBMS relationship between two tables or files are maintained programmatically, but in RDBMS relationship between two tables or files can be specified at the time of table creation. 
• In DBMS,client server concept is not present. In RDBMS,client server architecture is present (i.e) the client sends the request to the server and the server responds to that particular request.
• In DBMS there is less security of data, were as in RDBMS there are multiple levels of security
• DBMS does not support Distributed databases, were as RDBMS supports.
• Each table is given an extension in DBMS, but in RDBMS many tables are grouped in one database in RDBMS. 

Main Differences in Naming conventions

•  Field in DBMS column, Attributes in RDBMS.
• Record in DBMS Row, Tuple, Entity in RDBMS.
• File in DBMS Table, Relation. Entity Class. 

10:03