Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

dbms
rdbms
vs
database
software

DBMS vs. RDBMS

Educative Answers Team

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

  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 to reduce redundancy of data.

  4. Atomicity, Consistency, Isolation, and Durability.

svg viewer
Microsoft SQL Server is an example of RDBMS.

RELATED TAGS

dbms
rdbms
vs
database
software
Copyright ©2022 Educative, Inc. All rights reserved
RELATED COURSES

View all Courses

Keep Exploring