Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

How to implement database security?

0 Answers  


wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

0 Answers  


Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key

1 Answers   Ignou,


please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

0 Answers  


what is transaction state, buffer management, shadow paging

0 Answers  


What is the differnce between Order by and Group by

1 Answers  


define primary key index, bitmap index, hash index,virtual indwx

0 Answers   Cap Gemini,


Write the major components of a Database Management System?

3 Answers  


i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?

0 Answers  


issues involved in modeling and building data werahouses

0 Answers  


5. Explain about relational algebra.

0 Answers  


in informatica workflow has 5 sessions and running seqentially and 3rd session has been failed how can we run again from only 3rd to 5th session

1 Answers  


Categories