Normalize a Data Structure in SQL Server

hi,

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

Please check these articles:

http://www.c-sharpcorner.com/uploadfile/nipuntomar/normalization-and-its-types/

http://www.c-sharpcorner.com/UploadFile/shiv_koirala/SQLInt00112192007082753AM/SQLInt001.aspx