Question

DBMS has many functions. What three functions are the most important and why are they most important? What one benefit of a DBMS would you be willing to give up and why?

Answer 1

Three most important functions of DBMS are:

• Integrity - A database always maintains data integrity. It is important because organizations depends on data. Loss/corruption/malfunctioning of data will lead to a disaster for the organization. Hence, it is necessary that the database must be complete, accurate and consistent.
• Security - Security is the most important feature we need. We cannot progress if our data gets leak to our rivals. Security in database is maintained mainly through authentication.
• Query language - This feature is important because it is one of the main cause of using a database in the first place. The programs in the database are made so that we can store, retrieve and manipulate data just by querying the database.

There is no such benefits of a DBMS that we would be willing to give up because it will result into loss of data and security which will be a headache for us. Database is created with features that we need desparately in today's world. The whole world depends on it, and it is mandatory for the database to have its features because we need security, consistency, non-redundancy, integrity authentication etc. otherwise we will face disaster. But, we can still give up some features of a DBMS if we don't rely on them, this totally depends on us. For example, if our organization is small and only one member is needed to handle the database then we can simply get rid of multiuser system as this will also reduce the complexity which in result will make the executions faster.