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

WHAT KIND OF TOOL BO IS?

0 Answers   APC,


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  


Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?

1 Answers  


How much does it cost to build a database?

0 Answers  


Define stored procedure?

0 Answers  


What is ole db ado?

0 Answers  


What is ole db in ssis?

0 Answers  


What is ole db provider for sql server?

0 Answers  


what is the difference between tuple calculus and domain calculus ?

2 Answers   Infosys,


There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?

0 Answers  


hai i want to learn oracle apps and i want to put the fake exp of one year so could you please suggest me which is best institute in hyderabad to learn oracle with real time project experience?

2 Answers  


Explain entity set?

0 Answers  


Categories