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 a reference table in database?

0 Answers  

how node connect with cpu?

0 Answers   IBM,

Is data lake a database?

0 Answers  

What do you mean by foreign key and primary key?

0 Answers   Zensar,

How many indexes can be created on a table?

0 Answers   Abacus,

A lowest level of security by most RDBMS is

0 Answers   Baan Infotech,

what is tkprof tool and how it is used???

0 Answers   Genpact,

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

0 Answers  

How to implement database security?

0 Answers  

Is storing images in a database a good idea?

0 Answers  

how can you perform lookup range in lookup stage expalin in detail?

0 Answers   IBM,

What is the difference between data source and database?

0 Answers  

For more Databases AllOther Interview Questions Click Here
Categories