Normal form in SQL Server

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.

First Normal Form (1NF)
First normal form (1NF) sets the very basic rules for an organized database:

    * Eliminate duplicative columns from the same table.
    * Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key).

Second Normal Form (2NF)
Second normal form (2NF) further addresses the concept of removing duplicative data:

    * Meet all the requirements of the first normal form.
    * Remove subsets of data that apply to multiple rows of a table and place them in separate tables.
    * Create relationships between these new tables and their predecessors through the use of foreign keys.

Example: CustomerTable

1st Normal Form: All column in in Same table
 CustomerCode, CustomerName,Addressline1, Addressline2, Addressline3, pincode, City,
 State, Country,
2nd Normal Form : create two table
 Customer : Code,Name, addressId
 Address  : AddressId,line1,line2,line3,pincode,city, state.

hope this help