Answered: Why normalisation method is important…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

1. Why normalisation method is important in performing data analysis.

Expert Solution

Step 1

First of all, we will look at what is normalization -

Data normalization is a technique that reorganizes data within a database so that users may effectively use that database for further analysis. It is the process of integrating data into a much more organized structure.

The process of data normalization is as follows -

Remove any duplicate data that may exist within the collection of data. Because, redundant data may cause critical impact on data analysis since they are values that aren't necessary.
Reconciling any data that appears to be contradictory. Data normalization is used to address and resolve conflicting information in datasets.
Another step is data formatting. This transforms data into a format that enables for additional processing and analysis.