A database is an organized collection of data.
DBMS refers to the Database Management System. It is a set of programs that enables you to store, modify, and retrieve the data from a database.
RDBMS refers to the Relational Database Management System. It is a database management system that is based on the relational model as introduced by E. F. Codd. All modern database systems like MS SQL Server, Oracle, IBM DB2, MySQL, and Microsoft Access are based on RDBMS.
Difference between DBMS and RDBMS:
- 1. DBMS does not define any constraints or security to ensure the ACID PROPERTY.
- 2. Normalization concept is not present.
- 3. In DBMS data is treated as files internally.
- 4. DBMS does not support distributed databases.
- 5. DBMS supports single user.
- 1. RDBMS define the integrity constraint to ensure the ACID PROPERTY.
- 2. Normalization concept is present.
- 3. In RDBMS data is treated as tables internally.
- 4. RDBMS support distributed databases.
- 5. RDBMS supports multiple users.
Next Topic: SQL Syntax.
Previous Topic: SQL overview.