Normalization in SqlServer

Question

What is Normalization in sqlserver ? Why we used it ?

Aarti · Answer

Hi Rajesh, Normalization: a relational database is basically composed of tables that contain related data. So the Process of organizing this data into tables is actually referred to as normalization. Please Refer below like. I hope it will help you. http://msdn.microsoft.com/en-us/library/aa933055(v=sql.80).aspx Thanks.

Priyaranjan K S · Answer

Rajesh, Normalization is the process of organizing data into tables in such a way that the results of using the database are always unambiguous and as intended. Normalization may have the effect of duplicating data within the database and often results in the creation of additional tables. (While normalization tends to increase the duplication of data, it does not introduce redundancy, which is unnecessary duplication.) Normalization is typically a refinement process after the initial exercise of identifying the data objects that should be in the database, identifying their relationships, and defining the tables required and the columns within each table. You may read this blog : https://www.simple-talk.com/community/forums/thread/111401.aspx Or View this video for better understanding https://www.youtube.com/watch?v=wp0N1tYjEWc Thanks, Priyan If you found this useful Please mark this as Answer

Sivaraman Dhamodaran · Answer

The below atricle will help: Article [ http://www.mstecharticles.com/2010/11/normalization-of-data.html ]

Prabhu Raja · Answer

Small and Smart Definition Sam sir,

Sam Hobbs · Answer

Normalization was introduced by Edgar F. Codd, the inventor of the Relational model of databases. The primary purpose of normalization is to reduce redundancy in data. Elimination of redundancy is one of the fundamental design criteria for relational databases.

Prabhu Raja · Answer

Check out this good article by nipun Tomar http://www.c-sharpcorner.com/UploadFile/nipuntomar/6132/

Javeed M Shaikh · Answer

Hi Rajesh, Please refer to this article from c# Corner: http://www.c-sharpcorner.com/UploadFile/6897bc/4277/ Please do not forget to mark "Accepted Answer".