Advantages And Disadvantages Of Relational Database Management System

1110 Words5 Pages
Relational Database Management System:
This type of database management system that stores the data in the form of related tables. It is a social database administrator which deals with some typical kind of queries and uses SQL for the development of the database. This type of database is a very powerful database as it deals with the relations which makes the data manipulations easier other than any other database. It has the features of data entry, data deletion, and creating of new entry and records etc. the database provides the ease of accessing and maintaining data easily.
Advantages of RDBMS:
1. Prevents Data redundancy:
In relational database management systems the tables with the specific data have relation among them that’s why the required data is taken from the previous tables which prevents the data redundancy.
2. Data security:
In a relational database management system the data access is privileged which means that the database administrator has the authority of giving access of data to some particular users which makes the data secure.
3. Easy to use:
This type of database uses tables which is better and easy to create and use.
Disadvantages of RDBMS:
1. Slow:
As compared to other databases this database has a slow extraction of results thus making it a slower database.
2. Memory space:
The database uses tables having rows and columns which consumes a lot of physical memory which becomes a disadvantage of the database.
P a g e 2 | 5
3. Complexity:
The idea of