devika

• Sep 9th, 2011

 

Database normalization is a data design and organization process applied to data structures based on rules that help build relational databases.

Normalization usually involves dividing a database into two or more tables and defining relationships between the tables.

Steven

• Oct 4th, 2011

 

Normalizatiopn is the process of splitting tables up to reduce record redundancy. For instance if you have a table of addresses you may want to create a table of cities and link the addresses to the cities table in a foreign key. Since the city names would be identical on several records this would save a lot of space.

In some cases if tables are not normalized the amount of space they would take up would be so large that it would not be possible to record the data. The amount of normalization that you choose would depend upon how often field data is repeated throughout the table.

rayudu

• Oct 11th, 2011

 

normalizatilon is the process of organizing the table to minimize the redundency

Jatin Girdhar, Gurgaon

• Oct 12th, 2015

 

SQL Normalization is a systematic approach of de-composing tables to:

1. To eliminate redundant (useless) data
2. To store the data logically

Benefits:
1. Removes Data redundancy
2. Improves performance
3. Query Optimization
4. Faster update due to LESS NUMBER OF COLUMNS IN ONE TABLE (most important)
5. Index improvement

Various forms
1 First Normal Form (1NF)
2. 2NF
3. 3NF
4. BCNF (Boyce & Codd Normal form)