Discuss the major capabilities of DBMS and why is a relation

Solution

DBMS :-

DBMS is a software or tool which can be used for managing and maintaining the data within the database.

Major Capabilities of DBMS :-

1.Data Storage

2.Data Retrieval

3.Data Update

4.Security

5.Data Independence

Explanation :-

Generally a person has to work with huge amount of information everyday. Inorder to interact with the large amount of data we need a system where we can store, manipulate, security, sharing the information all over the world. It is a core reason the industries are maintaining database management tools.

A relational DBMS is so powerful. Because :-

* In RDBMS model the data will be stored in the form of tabular format. where as table is nothing but a collection of rows and columns.

* RDBMS model will provide high level security by using authentication and autherisation.

* RDBMS maintains accurate and consistency of the data with the help of data integrity mechanism.

* RDBMS supports the data manipulations by using DML commands.

* RDBMS provides faster rate retrieving the data by using index mechanism.