DBMS vs. RDBMS
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.
DBMS
Data is stored as a hierarchy in a file.
No relationship[1] between the data.
No constraint on the values entered in the database.
Normalization[3] is not supported.
The ACID[4] model is not followed when performing operations.
RDBMS
Data is stored as rows and columns in a table.
Tables have relationships to ensure consistency.
Integrity constraints[2] are applied to the data.
Normalization is supported.
Most operations adhere to the ACID properties.
Brief explanation
-
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.
-
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.
-
Normalization is a technique used in designing database schemas to reduce redundancy of data.
-
Atomicity, Consistency, Isolation, and Durability.
Free Resources
