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.
Depending upon the requiement you can choose 1st, 2nd and 3rd normalization.
Jignesh TrivediPosted Apr 25, 2012, 11:59 PM
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.
Depending upon the requiement you can choose 1st, 2nd and 3rd normalization.
Please go through
http://www.sqlinfo.net/sqlserver/sql_server_manipulating_denormalized_data.php
VulpesPosted Apr 25, 2012, 4:18 PM
http://www.c-sharpcorner.com/uploadfile/nipuntomar/normalization-and-its-types/
http://www.c-sharpcorner.com/UploadFile/shiv_koirala/SQLInt00112192007082753AM/SQLInt001.aspx