Sign Up Login


  1. Categories >> Software >> Databases >> Databases AllOther
  2. Suggest New Category

can any one explain about normalization forms with clear
explanation in interview point of view.
thanks for ur answers.

Question Posted / manikandan


can any one explain about normalization forms with clear explanation in interview point of view. t..

Answer / ajeet khari

normalization is organizing data efficiently into database...
main thing is 1.elimination of redundant data,2. data
dependencies..
1NF-a table is decomposed into 2D table with no duplicate
column....
2nd NF- should be in 1NF and there should not be any
duplicate row...
3NF- should be in 2NF and contains transitive dependencies
remove that column which are not dependent on PK.
4NF-should be in 3NF and it has no malti valued dependencies.

Is This Answer Correct ?    10 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

What is ole db ado?

0 Answers  

How many types of locks are present in a database?

0 Answers   Abacus,

How does rows store in Teradata

1 Answers  

How does database replication work?

0 Answers  

Write a query to retrieve for many to many relationships?

0 Answers   CGI,

What is the differnce between Order by and Group by

1 Answers  

what is primary key,unique key, foreign key? can u teach me in simple language?

44 Answers   Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

0 Answers  

Clipper / DBF error

1 Answers  

Is data lake a database?

0 Answers  

What is the Difference Primary key and Unique Key

0 Answers   HCL,

What is a database example?

0 Answers  

For more Databases AllOther Interview Questions Click Here
Categories