NORMALIZATION
- Nov 21, 2015
- 1 min read
WHAT IS NORMALIZATION?
-Normalization is a technique of analyzing and correcting table structure for producing a set of suitable relations that support the data requirements of an enterprise.
WHY DO WE USE NORMALIZATION?
-is a technique to organize the contents of the tables for transactional databases and data warehouses.
-is part of successful database design.
-without normalization, database systems can be inaccurate, slow, and inefficient, and they might not produce the data you expect.
Major aim of relational database design (i.e normalization) is to group attributes into relations to minimize data redundancy.
-Relations that contain redundant information may potentially suffer from update anomalies.
Types of update anomalies include
¤Insertion
¤Deletion
¤Modification
CONVERSION TO 1NF
CONVERSION TO 2NF
CONVERSION TO 3NF
Comments