What is normalization? Explain different forms of normalization?



What is normalization? Explain different forms of normalization?..

Answer / Santosh Kumar

Normalization is the process of organizing data in a database to minimize redundancy and dependency. It helps ensure that each piece of information is stored only once, making databases more efficient, easy to manage, and less prone to errors. There are three main forms of normalization: First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How can sql injection be stopped? : sql server security

1 Answers  


explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1 Answers  


Explain differentiate between a having clause and a where clause?

1 Answers  


Why do you want to join software field as you have done your BE in Electronics?

1 Answers   Cap Gemini, HCL,


How raid can influence database performance?

0 Answers  


Explain about system stored procedure?

1 Answers  


Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1 Answers  


Explain about system database?

1 Answers  


What is collation sensitivity? Explain different types.

1 Answers  


How does normalization work?

1 Answers  


Explain sql delete command?

1 Answers  


When do u use clustered index and non-clustered index?

3 Answers   IBM,


Categories