Submitted by: Submitted by smbridges
Views: 264
Words: 872
Pages: 4
Category: Business and Industry
Date Submitted: 07/19/2013 01:47 PM
Introduction
In this day and age businesses must handle a vast amount of information on a daily basis. In order to be to be successful businesses must deal with this information in the most effective and accurate way. With the use of database management systems this can be accomplished in easily in the most straightforward way.
Benefits of a Database Management System
There are several benefits when using a database management system. The first would be controlling data redundancy and consistency. When using a DBMS all data in the organization is implemented into one database and is not duplicated in several locations (Jittla, 2012). With the use of a primary and a secondary key the database management system can reduce redundancy of data and implement systematic storage (Satalkar, 2011). With the implementation of integrity constraints the DBMS prevents nonessential information to be stored within the database (Basics of Computer, 2012).
With the benefits of integrity constraints and the elimination of data redundancy provides data consistency, to be able to handle the modern business needs and can support an immense amount of information. A DBMS such as SQL or Oracle could simply provide all the needed data volume for a national restraint chain and provide for easy growth of the company. When using software similar to Microsoft Excel the organization could lag behind from the inadequate data feature and the added redundancy.
A DBMS offers Structured Query Language (SQL), which enables the users to be able to obtain large amount of information quickly and easily. If there is a need to be able to see the aggregated sales data for a certain range of data for a certain store to see the results can be simply manipulated with an SQL statement. This type of query would not require linking worksheets, creating new worksheets, or the creation of formulas as would have to be done in a product such as excel.
Downfall of flat file systems
For larger...