Advantages And Disadvantages Of A Relational Database Management System

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

A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.

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.

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

Example 1 – Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment:

(Shelly, Cashman, Waggoner 1992). However, the arrival on the scene of the relational database along with the rapidly changing technology has modified the database administrator's role. This has required organizations to vary the way of handling database management.

A kind of database organisation system that every record style can have many owner .As well as this model allows for data relationships many way, for instance order are owned by customers and goods.

Next, I will address the advantages of a relational model specific to ACME Global Consulting. Since Acme Global Consulting is a leader in providing software development solutions to other companies, they need to have an in-depth knowledge of their clients functional and data needs. Therefore, a relational model can provide great benefits such as: (1). Conceptual simplicity: the model is very simple and helps to simplify data needs of their clients, (2). Design implementation: the model will help the company to achieve structural and data independence i.e. any changes if made to structure of data will not affect accessibility of data, and (3) Ad hoc capability of query implementation: relational model provides a very easy and flexible way of data implementation and manipulation. In addition, a relational model helps to organize data in form of tables. A relational model is composed of three main components: (1), a set of domains and sets that represents data structure, (2). Integrity rules, which ensures data protection, and (3). Operations that will be carried on data i.e. process of data manipulation. The experts on relational models say that it is the most widely used and most evolved method of organizing data Today, all major database management systems assume that you will be working in some manner with the relational model (Date, 2012, p.

The database relationship also helps further improve table structure and reduce redundant data. With associated tables of information being connected, the user can improve both tables of related information simultaneously.

Data redundancy could be defined as keeping the same piece of data in two separate places within a database or data storage technology. Traditional file-based systems stores the same information in more than one file through which space is wasted unnecessarily. But the DBMS ensure that multiple copies of the same data are not stored by integrating the files to eliminate the redundancy. Sometimes, it is necessary to duplicate key data items to model relationships. Moreover, it is desirable to duplicate some data items to improve performance. Due to above reasons DBMS does not eliminate redundancy entirely.

In todays era, the volume of data we manage has developed to terabytes. As the volume of data continues developing, the sorts of data produced by applications get to be wealthier than some time recently. Subsequently, traditional relational databases are tested to catch, visualize, seek, share, break down, and store data. We find many difficulties in managing big data using traditional data modeling techniques. We still need an advance modeling techniques threw which we can solve problems of managing big data. There are two types of data models in data base system one is relational model and other is non

The Relational database and the No SQL database are both appropriate database methods depending on the way they are being implemented and the purpose of the business for which they are being incorporated. However, both the database approaches have distinct wide variety of characteristics, based on which they can be compared and contrasted in the following way.

There are significant advantages to using databases in a business, especially in large companies. The main benefit of databases is that they save time. With the use of a simple queries, millions of records can be searches in a matter of seconds to give the information needed. Think about how long it would take to go through a million paper records held in files.

A database system would offer the innkeepers several advantages over the flat file system, including enforced data integrity, minimized effort to adapt data into usable information, and abstraction.