**Database Management System (DBMS)** and **Relational Database Management System (RDBMS)** are two types of software used to manage databases.

The key differences between the two are stated below.

<center>

**DBMS**

<hr>

Data is stored as a hierarchy in a file. 
 
<hr>

No relationship[1] between the data. 
 
<hr>

No constraint on the values entered in the database.
<hr>

Normalization[3] is not supported.
<hr>

The *ACID*[4] model is not followed when performing operations.
<hr>
</center>

<center>

**RDBMS**

<hr>

Data is stored as rows and columns in a table.
<hr>

Tables have relationships to ensure consistency.
<hr>

Integrity constraints[2] are applied to the data.
<hr>

Normalization is supported.
<hr>

Most operations adhere to the *ACID* properties.
<hr>
</center>

# Brief explanation

1. A relationship between two tables in a database is based on a *Primary Key* and a *Foreign Key* -- it ensures that the common data between two tables is consistent.

2. For example, making sure that:

   **(i)** A number is not entered in place of a name.

   **(ii)** Necessary fields, like *ID*, *Password*, etc. are not empty.

   **(iii)** Fields like *Username* and *Email* have a unique value.

   **(iv)** Tables in a relationship have consistent data.

3. Normalization is a technique used in designing [database schemas](https://www.educative.io/answers/what-is-a-database-schema) to reduce redundancy of data.

4. Atomicity, Consistency, Isolation, and Durability.

DBMS vs. RDBMS

Brief explanation