What Is Normalization In Sql Server DBMS?


5 Answers

Tausif Akram Profile
Tausif Akram answered
Normalization is a technique that is adopted before the designing and development phase of any database. There are six normalization forms that are to be followed in order to have perfect database. When making a database there are various point that are required to addresses otherwise you might have too many non-required columns and you may not have the desired columns as per system requirements. Although you might be able to add new column and delete as well but it is always recommended to normalize the database before creating it. In the normalization process primary key is identified and candidate keys are also identified for primary key, manual system is analysed before converting into columns and types of columns.

Normalization also makes sure that there is no repetition of the columns and minimum numbers of columns are defined and usability of each column is most. Normalization also identifies the number of table that is required in a specific database development and what will the data types of each column. There are various interpretations available in the form of books from different authors about normalization. It also identify which column should be index and whether you should have unique index or composite index because they also play very vital role in the searching the records from tables.
Anonymous Profile
Anonymous answered
Its the technique to reduce redundant table data to the very minimum. Through  this process data of single table is replaced  by multiple tables with a specific relationship setup between the tables.
Anonymous Profile
Anonymous answered
Chips Ters Profile
Chips Ters answered

Hmm .. Well there most likely the problem exists on a different level. Read this blog and how to work with partition by in sql correctly, this may be exactly the problem. In fact, in this blog, you will find many solutions to basic problems when working with SKL that you don't even know about. Wish you good luck!

sivaganesh Profile
sivaganesh answered
Normalization refers to analysing the database based on functional dependencies with the aim to reduce the redundancy and the insert, update and delete operation on the database.

Answer Question