Normalize a Data Structure in SQL Server

Question

Hi friends I want to know how normalize a data structure in SQL Server. Thank you.

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. 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

Vulpes · Answer

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