Software job search
.net sql interview questions
  The best place for technical interview questions

 
Home.netSql serverAsp.netC#Vb.netAdo.netAjaxMcpd dumpsWord count tool
You are here >> sql server interview questions  
Question. What are different types of normalization


1NF - First Normal form defines that no two rows of data contain repeating information or each set of column should have a unique value.

Ex –
StudentName Subjects
--------------------------------------------------------------------
John English,Maths

The above table when converted to 1NF will be like this

StudentName Subjects
--------------------------------------------------------------------
John English
John Maths

2NF – In order to be in 2NF it should satisfy the below conditions
1) It should be in 1NF.
2) All non-key attributes should have a dependency on the primary key.

3NF - In order to be in 2NF it should satisfy the below conditions
1) It should be in 1NF.
2) All non-key attributes should have a dependency only on the primary key. If there is a dependency other than the primary key those should be moved to a separate table.

4NF – It is also known as Boyce–Codd normal form (BCNF). It is a slightly higher version on 3NF.
In order to be in 2NF it should satisfy the below conditions
1) It should be in 1NF.
2) It should not have multiple overlapping candidate keys







Previous question Next question
 Rate this answer
     
 26 votes , average 4 out of 5

Back to sql server interview questions
This question has been viewed 13450 times   

Other questions on sql server interview questions




More SQL Server interview questions
SQL Server interview questions

Reader's opinions -

No comments
Loading

 
.net interview questions
Asp.net interview questions
C# interview questions
Vb.net interview questions
Ado.net interview questions
Ajax interview questions
Wcf interview questions
Wpf interview questions
.net threading interview questions
.net remoting and webservices interview questions
.net caching interview questions
.net oops interview questions
Sharepoint interview questions
Jquery interview questions
Silverlight interview questions
Linq interview questions
Wwf interview questions
Java interview questions
Sql server interview questions
Ssis interview questions
Ssrs interview questions
Data warehousing interview questions
Data mining interview questions
Oracle interview questions
Php interview questions
Design patterns interview questions
Uml interview questions
Mcpd dumps
Pmp practice tests

This site is best viewed with Internet Explorer 7.0 or higher, Firefox 2.0 or higher, Chrome at a minimum screen resolution of 1024x768.
A complete solution to interview questions
free matrimonial website      
web hosting plans |  compare vps hosting plans |  Compare dedicated hosting plans |  Compare linux hosting plans |  Compare cloud hosting plans |  Compare windows hosting plans | 
Hosting reviews |  GoDaddy reviews | 
Support Wikipedia