Question

In you own words explain what relationship database is. Discuss the benefits of using relationship database for improving workflow and efficiency of business decision-making processes.

Answer 1

RDBMS or Relational Data Base Management System is the organization's of data into tables which are related to each other based on common data to each table.

The benefits and advantages of RDBMS are as follows:

1. IT ensures flexibility and reliability by fetching data from two or more table with a single query thereby minimizing time.

2. it helps to create a meaningful information.by joining the tables which helps to understand the relationship between the data or how the tables connect to each other

3 Relational database reduce data redundancy as information for a single customer appears in one place. Basically the practice if separating data to avoid redundancy is called normalization which today's software engineers uses to make sure that the tables are being normalized during the design process

4 Relational Database Management Systems helps to facilitate easy backup and disaster recovery. The RDBMS offers easy export and import options making backup and recovery more flexible and easy

5 RDBMS makes the database more flexible

as it helps to apply CRUD rules at one single point of query that is you don't need to update each and every table simultaneously if the tables are related to each other. A single query will help to perform the following operations ensuring flexibility