Normalization in SqlServer

Rajesh Kumar

15y2.2k

What is Normalization in sqlserver ? Why we used it ?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Priyaranjan K S11y ago
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
0
Sivaraman Dhamodaran11y ago
The below atricle will help: Article [ http://www.mstecharticles.com/2010/11/normalization-of-data.html ]
0
Prabhu Raja15y ago
Small and Smart Definition Sam sir,
0
Sam Hobbs15y ago
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.
0
Aarti15y ago
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.
0
Prabhu Raja15y ago
Check out this good article by nipun Tomar

http://www.c-sharpcorner.com/UploadFile/nipuntomar/6132/

0
Javeed M Shaikh15y ago
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".
0