What is Normalization?  


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

Database normalization is a data design and organization process applied to data structures based on rules that help building rlational databases. 
In relational database design, the process of organizing data to minimize redundancy is called normalization. 
Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. 
The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the define relationships.


Comments

Author: banu14 Dec 2010 Member Level: Gold   Points : 1

Normalization is the process of efficiently organizing data in a database

eliminating redundant data
ensuring data dependencies make sense

Types of Normalization
First normal form
Second Normal Form
Third Normal Form
Fourth Normal Form

Author: heartking15 Dec 2010 Member Level: Gold   Points : 1

Normalization is simply as

Cures the ‘SpreadSheet Syndrome’
Store only the minimal amount of information.
Remove redundancies.
Restructure data.

five types of normal form we have

1. First Normal Form (1NF)
2. Second Normal Form (2NF)
3. Third Normal Form (3NF)
4. Boyce-Codd Normal Form (BCNF)
5. Fourth Normal Form (4NF)
6. Fifth Normal Form (5NF)

Author: satyajee srivastava19 Dec 2010 Member Level: Silver   Points : 1

Normalization is the process of organizing the data of a database. This includes creating tables and establishing relationships between those tables.

All of this is done according to rules designed both to protect the data and to make the database more flexible. Data normalization is primarily used in transactional processing.
The two key goals of the normalization process are eliminating redundant data and ensuring that data dependencies make sense. Eliminating redundant data implies storing the same data in more than one table and ensuring that data dependencies makes sense implies only storing related data in a table.

Author: Heartly22 Dec 2010 Member Level: Gold   Points : 1

Database normalization is the process of removing redundant data from your tables in to improve storage efficiency, data integrity, and scalability.
In the relational model, methods exist for quantifying how efficient a database is. These classifications are called normal forms (or NF), and there are algorithms for converting a given database between them.
Normalization generally involves splitting existing tables into multiple ones, which must be re-joined or linked each time a query is issued.


Edgar F. Codd originally established three normal forms: 1NF, 2NF and 3NF. There are now others that are generally accepted, but 3NF is widely considered to be sufficient for most applications. Most tables when reaching 3NF are also in BCNF (Boyce-Codd Normal Form).

Author: murali04 Jan 2011 Member Level: Bronze   Points : 1

Normalization is the way of organizing data in a database by removing redundancy and inconsistent dependency.
Database normalization has the rules to be followed while creating databases.
Each rule is called as normal form.
First Normal form states - Remove duplicate column and identify each set of related data with a primary key.
Second normal form - Create relationship between master and master detail tables using foreign key.
Third normal form - Remove the fields that do not depend on the primary key.

It is the process of organizing data into related table.
To normalize database, we divide database into tables and establish relationships between the tables.
It reduces redundancy. It is done to improve performance of query.

Author: sugandha18 Jan 2011 Member Level: Gold   Points : 1

Normalization is a process of decomposing tables to eliminate data redundancy.

1N.F:- The table should caontain scalar or atomic values.
2 N.F:- Table should be in 1N.F + No partial functional dependencies
3 N.F :-Table should be in 2 N.F + No transitive dependencies

Author: manju24 Jan 2011 Member Level: Silver   Points : 1

the process of organizing data to minimize redundancy is called normalization
1.first normal form-avoid duplicate columns from same table
2.Second normal form-realtional key between tables.
3.Third noraml form-remove dependant co;lumns from tables.
4.fourth normal form-same as thord.no multi-valued dependancies

Author: ketan Italiya09 Oct 2013 Member Level: Gold   Points : 3

Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.

Author: Phagu Mahato16 Oct 2013 Member Level: Gold   Points : 10

Database designed supported ER model might need some amount of inconsistency, ambiguity and redundancy. To resolve these issues some amount of refinement is required. This refinement technique is termed as standardization.
Or we have a tendency to are ready to say that standardization is that the strategy of organizing data into a connected table; it together eliminates redundancy and can increase the integrity that improves performance of the question. To normalize a information, we have a tendency to tend to divide the information into tables and establish relationships between the tables.

Database standardization can primarily be made public as a result of the observe of optimizing table structures. improvement is accomplished as a results of a radical investigation of the various things of data which will be hold on within the information, specially concentrating upon but this data is cancellation.

Normal forms in SQL unit given below.

First Normal Form

For a table to be in initial ancient kind, data ought to be uneven into the tiniest units potential. to boot to breaking data up into the tiniest meaty values, tables in initial ancient kind mustn't contain repetitions groups of fields.

Second Normal Form

The second ancient kind states that each field throughout a multiple field primary key table ought to be directly related to the total primary key. In various words, each non-key field got to be a truth concerning all the fields inside the first key..

Third Normal Form (3NF): we have a tendency to ar spoken communication that a relation is in 3NF if it's in 2NF and has no transitive dependencies. Boyce-Codd Normal Form (BCNF): A relation is claimed to be in
BCNF if and providing every determinant inside the relation may well be a candidate key.

Fourth Normal Form (4NF): A relation is claimed to be in 4NF if it's in BCNF and contains no multi valued attributes.

Fifth Normal Form (5NF): A relation is claimed to be in 5NF if and providing every be a neighborhood of dependency in relation is silent by the candidate keys of relation.

Domain-Key Normal Form (DKNF): we have a tendency to ar spoken communication that a relation is in DKNF if it's free of all modification anomalies. Insertion, Deletion, and update anomalies return beneath modification anomalies.



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: