What Are The Advantages And Disadvantages Of A Database Management System

Be sure to provide a detailed explanation of relational databases along with their associated business advantages.

It will create a clear purpose of the database and each one of the tables within making maintenance easy to perform on weekly basis and security breaches easy to spot. The quick and efficient accessibility of the data will improve timing in business reporting turnaround and therefor increase sales and profit by quick and easy business response to market changes. Security concerns will be limited by creating admin account that can control and modify the system and users that can access it without any system modifications allowed. Main server and system will be backed up on an external drive and supported by external power source so no data will be lost if database is not

This must be in your own words and not copied and pasted from the original source. Include the purpose of the database and the subject matter it covers. This may be four or five sentences; and

Increased reliability and availability: A distributed database system has multiple nodes (computers) and if one fails then others are available to do the job. So we can say that redundancy and replication of the DB increase security and accessibility.

Company must also develop a clear structure for granting employees access to sensitive information. Not all employees need such data in order to fulfill their everyday job responsibilities. For those who need admission to sensitive information, a strong authentication mechanism must be developed, which cannot be bypassed. This will ensure that only authorized users are accessing compromising data.

A database administrator role in a company is vital to the future success. According to the Bureau of Labor Statistics, database admins use computer programs and special software to organize data, and turn it into information for its users. Of the three positions at Vigo, a database administrator requires the highest level of education, prior job experience and training. The responsibilities include protecting data from breaches, providing ease of access to users, and be able to work with management to create goals based off the data. The median annual income for database administrators is about $85,000. The projected growth is

The tables in relational databases organize data in rows and columns, simplifying data access and manipulation. It is easier for manager to understand the relational model than put all data in one table. Besides, a relational database allows tables to be linked. And the linkage reduces data redundancy and allows data to be organized more logically. In a word, relational database is easier to control, more flexible, and more intuitive than approaches.

A database administrator (DBA) according to dictionary.com (2015) is an IT professional responsible for the installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases in an organization. These individuals within the company have total rights to all systems because they are administrators. The users of the system are just that, they use the system to complete task and work for the company or organization from their area. Now users can ask the administrators to help or do certain task within the system. For example, the user needs a certain spread sheet done for where it is a read open or for only certain people to be able to access certain spread sheets.

Database administrators must create ways to store, analyze, utilize, and organize data. A DBA develops computer databases based on user needs and migrate data from old systems to new systems. DBA’s ensure that business data is accurate, available and secure. The specific requirements for a DBA position include having a minimum of a bachelor’s degree in Computer Science and expert knowledge on SQL. SQL is the standard language for relational database management systems. For this position one must also be an expert with Microsoft SQL Server mirroring and replication.

Take inventory for example, Linton (n.d.) stated that “by using a database, you can replace manual methods of inventory control and reduce the time, cost and effort of inventory management” (para. 1). So basically, databases streamline the processes. When time is saved, productivity is increased. You can also look at this project to see how businesses utilize databases for their employee information. The forms that were created for this project show just how simplified inputting information has become. Almost everything is now in one database, and it can be shared across tables. It is the same concept for customer information.

DBMS can improve business efficiency by providing a highly efficient method for handling multiple types of data. For example, staff records, customer information, services rate, accounting, and inventory are all easy to manage when it uses this kind of system.

One advantage to using relational databases include ease of use due to query languages, and the ease of altering the structure due to data independence. In addition, there are no predefined set of relationships between data records in the relational

The responsibility of a database administrator is to serve as the link between the database designers, knowledge managers and users. The database designers are often brought in for completing specific projects and then moving onto other projects at other companies or different departments at the same company. Their job are usually finished when they finish designing the database. While they may be used in the future to perform some

This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS.

Other than the factors mentioned so far, below listed are a few more advantages of SQL for a business: