1.

Why is it suggested to utilise a database management system (DBMS)? List some of its primary advantages to explain.

Answer»

Following are some advantages of using DBMS:

  • Minimizing Data REDUNDANCY: DBMS SUPPORTS a system to eliminate data redundancy within the database by integrating all data into a single database, and because data is stored in only one location, there is no duplication of data.
  • Data Sharing: In a DBMS, data can be shared among several users at the same time because the same database is shared across all users and by various applications.
  • Data Integrity: This REFERS to the database's data being consistent and accurate at all times. It is CRITICAL because a database MANAGEMENT system (DBMS) contains numerous databases, each of which contains data that is visible to multiple users. As a result, it's critical to guarantee that data is accurate and consistent across all databases and for all users.
  • Data Security: Only approved users should be allowed access to the database, and their identities should be authenticated using a legitimate login and password. Under no circumstances should unauthorized users be allowed to access the database, as this would break the integrity limitations.


Discussion

No Comment Found