What is normalization? What are different type of normalization?explain with example?

Question

briefly explain with sql server query example

Answer 1

There are basically 3 types of normalization. 1rst (not normalized at all) 2cnd, and 3rd. It can go to 4rth and 5th too, but I've never seen it.

If you normalize a database it means to design it so that you try not to store redundant data. Instead of having on table or spreadsheet to hold info about everything, you would create several small tables - like a table called Customer - it just stores info about a customer. Items table, SalesOrder table ....

Answer 2

Normalization

Normalization is a design technique that is widely used as a guide in designing relational databases. Normalization is essentially a two step process that puts data into tabular form by removing repeating groups and then removes duplicated data from the relational tables.

For Basic Definition and Examples Refer:
http://www.databasejournal.com/sqletc/article.php/26861_1428511_3
http://www.webopedia.com/TERM/N/normalization.html

For Advanced Details Refer:
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html