Normal form in SQL Server

Question

Hi...

I have confusion in first normal form and second normal form ? Please explain all normal form in database with simple example ?
Please explain difference between redundency and consistancy ?

Thanks.......

Jignesh Trivedi · Answer

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. 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 CustomerNameAddressline1 Addressline2 Addressline3 pincode City State Country 2nd Normal Form : create two table Customer : CodeName addressId Address : AddressIdline1line2line3pincodecity state. hope this help

Satyapriya Nayak · Answer

Hi Vineet Please refer the below link http://www.c-sharpcorner.com/uploadfile/nipuntomar/normalization-and-its-types/ Thanks