Difference between DBMS and RDBMS

Computer EngineeringComputer NetworkMCA

DBMS represents a Database Management System. It is used to create/update/delete and maintain a database and it provides controlled access to data. RDBMS, Relational Database Management System, is an enhanced version of DBMS.

Following are the important differences between DBMS and RDBMS.

Sr. No.KeyDBMSRDBMS
1DefinitionDBMS stands for DataBase Management System.RDBMS stands for Relational DataBase Management System.
2Data StorageData is stored as file.Data is stored as tables.
3Data AccessIn DBMS, each data elements are to be accessed individually.In RDBMS, multiple data elements can be accessed at same time.
4RelationshipThere is no relationship between data in DBMS.Data is present in multiple tables which can be related to each other.
5NormalizationNormalization cannot be achieved.Normalization can be achieved.
6Distributed databaseDBMS has no support for distributed databases.RDBMS supports distributed databases.
7Data QuantityDBMS deals with small quantity of data.RDBMS deals with large quantity of data.
8Data RedundancyData Redundancy is common in DBMS.Data Redundancy can be reduced using key and indexes in RDBMS.
9UserDBMS supports single user at a time.RDBMS supports multiple users at a time.
10SecurityDBMS provides low security during data manipulation.RDBMS has multilayer security during data manipulation.
11ExampleMSAccess.Oracle, SQL Server.
raja
Published on 27-Nov-2019 11:47:23
Advertisements