Explore BrainMass

Database Benefits and Drawbacks

What are the benefits (advantages) and drawbacks (disadvantages) of using a DBMS?

Solution Preview

Database Management System (DBMS)
Database management system (DBMS) is a combination of several programs that helps the users to store, change and take out information from a database (Coronel, Morris & Rob, 2012). It also facilitates its users by providing tools that could be used for adding, modifying, and analyzing stored data at any time. Hence, followings are some benefits and drawbacks of using a DBMS to its users:
Advantages of DBMS
A DBMS offers several advantages to its users related to the storage of important information and data at any time. Followings are some major advantages of DBMS:
Reduce Data Redundancy: DBMS resides whole data into a single system by that its users can access the information from any data files in a database. Therefore, it reduces the needs of duplicate data files (Longley, Goodchild, Maguire & Rhind, 2005). This situation also reduces redundancy of the data. Hence, its users may get accurate information.
Integration of Data: After the storage of data, DBMS integrates all data into a single database that helps the users to take out the required information easily (Hvasshovd, 2011). In addition, the users can use DBMS for imposing the rules of integrity by the help of minimum programming that could help the other DBMS users to handle the data management without any difficulty (Shelly & Vermaat, 2010). On the other hand, it ...

Solution Summary

The solution discusses the database benefits and drawbacks.