Question

Explain the characteristics of DBMS.

Answer 1

Characteristics of Database Management system:

Data stored in Table	Data is never directly stored in the database. Data is stored in tables, created inside the database. DBMS also allows having relationships between tables which makes the data more meaningful and connected.
Reduced Redundancy	In the modern world, hard drives are very cheap, but earlier when hard drives were too expensive, unnecessary repetition of data in databases was a big problem But DBMS follows Normalization which divides the data in such a way that repetition is minimum.
Data Consistency	On live data, it is being continuously updated and added, maintaining the consistency of data can become a challenge. But DBMS handles it by itself.
Support Multiple user and Concurrent Access	DBMS allows multiple users to work on it( update, insert, delete data) at the same time and still manages to maintain data consistency.
Query Language	DBMS provides users with a simple query language, using which data can be easily fetched, inserted, deleted, and updated in a database.
Security	The DBMS also takes care of the security of data, protecting the data from unauthorized access. In a typical DBMS, we can create user accounts with different access permissions, using which we can easily secure our data by restricting user access.
DBMS Supports Transac­tions	It allows us to better handle and manage data integrity in real-world applications where multi-threading is extensively used.