Question

“…Many different departments within an organization now require access to the same data. With conventional file processing, data are often duplicated in multiple files. Often data are stored in different formats in each of the files in which they are stored. On occasion, data which are stored in multiple files do not agree and time has to be expended to resolve these differences. (Sourced from an Academic journal) List and illustrate 2 benefits of a suitable database system to support a business like this.

Answer 1

ANSWERS :

ANS 1. The database system that is most suitable in this type of buisness is the Relational Database system .

The benifits of RDBMS is following :

1. In this all the data is stored in form of tables and each table has a primary key that reduces the duplicacy of data as it is unique for each row , thus the problem of duplicate data can be removed by using this.

2. The RDBMS provides ACID properties :

-- Atomicity

-- Consistency

-- Isolation

-- Durability

These all are very neccessary for the timely retrival of he data without any delay.

3. The RDBMS has the best support that is available right now thus it maximizes the effeciency.

The most commnly used RDBMS now is the following and we can choose any one of it :

-- Oracle Database

-- MySQL

-- Microsoft SQL server