Question

In: Computer Science

Explain the advantages of using Database Management System (DBMS) [10 marks]

  1. Explain the advantages of using Database Management System (DBMS) [10 marks]

Solutions

Expert Solution

A Database Management System (DBMS) is defined as the software system that allows users to define, create, maintain and control access to the database. DBMS makes it possible for end users to create, read, update and delete data in database. It is a layer between programs and data.

Compared to the File Based Data Management System, Database Management System has many advantages. Some of these advantages are given below −

Reducing Data Redundancy
The file based data management systems contained multiple files that were stored in many different locations in a system or even across multiple systems. Because of this, there were sometimes multiple copies of the same file which lead to data redundancy.

This is prevented in a database as there is a single database and any change in it is reflected immediately. Because of this, there is no chance of encountering duplicate data.

Sharing of Data
In a database, the users of the database can share the data among themselves. There are various levels of authorisation to access the data, and consequently the data can only be shared based on the correct authorisation protocols being followed.

Many remote users can also access the database simultaneously and share the data between themselves.

Data Integrity
Data integrity means that the data is accurate and consistent in the database. Data Integrity is very important as there are multiple databases in a DBMS. All of these databases contain data that is visible to multiple users. So it is necessary to ensure that the data is correct and consistent in all the databases and for all the users.

Data Security
Data Security is vital concept in a database. Only authorised users should be allowed to access the database and their identity should be authenticated using a username and password. Unauthorised users should not be allowed to access the database under any circumstances as it violates the integrity constraints.

Privacy
The privacy rule in a database means only the authorized users can access a database according to its privacy constraints. There are levels of database access and a user can only view the data he is allowed to. For example - In social networking sites, access constraints are different for different accounts a user may want to access.

Backup and Recovery
Database Management System automatically takes care of backup and recovery. The users don't need to backup data periodically because this is taken care of by the DBMS. Moreover, it also restores the database after a crash or system failure to its previous condition.

Data Consistency
Data consistency is ensured in a database because there is no data redundancy. All data appears consistently across the database and the data is same for all the users viewing the database. Moreover, any changes made to the database are immediately reflected to all the users and there is no data inconsistency.

Improved decision making

Better-managed data and improved data access make it possible to generate better-quality information, on which better decisions are based. The quality of the information generated depends on the quality of the underlying data. Data quality is a comprehensive approach to promoting the accuracy, validity, and timeliness of the data. While the DBMS does not guarantee data quality, it provides a framework to facilitate data quality initiatives.


Related Solutions

What is the Database Management System (DBMS)? Give example companies who are using DBMS in Saudi...
What is the Database Management System (DBMS)? Give example companies who are using DBMS in Saudi Arabia? (write max 200 words with evidence in your own words)
Q1: Explain the different database structures in database management system (DBMS) Q2: What are the roles...
Q1: Explain the different database structures in database management system (DBMS) Q2: What are the roles of OSI layers to transmit data from one computer to another computer?
A general-purpose database management system (DBMS) has 5 basic responsibilities: Interaction with the file management system...
A general-purpose database management system (DBMS) has 5 basic responsibilities: Interaction with the file management system Integrity enforcement Security enforcement Backup and Recovery Concurrency control For each responsibility, explain the problems that would arise if the DBMS did not execute these responsibilities. Be descriptive and give examples where appropriate.
Briefly describe the function of the DBMS in a database system.
Briefly describe the function of the DBMS in a database system.
book is database management system 13th adition 3. Discuss the advantages and disadvantages of using SQL...
book is database management system 13th adition 3. Discuss the advantages and disadvantages of using SQL to create a database. Also, what needs to be documented and why.
1. Advantages and disadvantages of Web-DBMS approach. Discuss the Web as a database platform 2. Compare...
1. Advantages and disadvantages of Web-DBMS approach. Discuss the Web as a database platform 2. Compare and contrast ER model and DM. 3. Describe the database design methodology for DW 4. Compare and contrast OLAP and OLTP
Database Design and Management Question: Discuss the security needs of DBMS solution. Recommend a comprehensive but...
Database Design and Management Question: Discuss the security needs of DBMS solution. Recommend a comprehensive but high-level security management plan for the design.
Explain why a database and a database management system are fundamental to business operations. Short Essay...
Explain why a database and a database management system are fundamental to business operations. Short Essay Question
Using your downloaded DBMS (MS SQL Server), create a new database. Create the database tables based...
Using your downloaded DBMS (MS SQL Server), create a new database. Create the database tables based on your entities defining The attributes within each table The primary and foreign keys within each table *****Show your database tables, tables attributes, primary and foreign keys***** Do not forget to check the lesson slides and videos that show you how to convert an ER/EER into a database schema, and how to create a database and tables using MS SQL Server.
What are some of the advantages of a relational database system?
What are some of the advantages of a relational database system?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT