Explain the six problems that can be minimized using the dat

Explain the six problems that can be minimized using the database approach?

Solution

Six problems that can be minimized using the database approach

The occurrence of the same data in multiple fields is known as data redundancy. This repetition of data can let to distortions and anomalies in the results.

By using database normalization we can minimize data redundancy by creating a singular well-organized table for editing fields and share information with the rest of the database from it.

2. Data Isolation

Data Isolation in respect to databases is specified when and how the changes are put into operation and become visible to other parallel operations.

Databases authorize users to set isolation levels. The isolation levels selected by user prevent applications from errors like dirty, repeatable and phantom reads.

3. Data Inconsistency

Data inconsistency in databases is the state that takes place between two or more files when alike data is kept in different formats in two different files.

If the redundancy is removed the chances of inconsistent data can also be removed.

4. Data Security

A database security is the significant asset to preserve and protect the sensitive data for an organization. Database security requires maintenance of a secure database.

To avoid data security issue is to make use of qualified personnel and divide the security responsibilities from the daily database maintenance responsibilities.

5. Data Integrity

Data integrity is the correctness and reliability of data stored in the database.

To assure data integrity includes:

6. Data Independence

Data independence is the design that generates and stores data that is kept separated from applications that uses the data for computing.