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

Is storing images in a database a good idea?

0 Answers  


How can we join three tables in SQL server 2000

2 Answers   Intelligroup,


What is the main difference b/w Teradata and Oracle?

1 Answers   TCS,


What do you mean by database?

0 Answers  


What is OQL?

4 Answers  


i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

0 Answers   Datamatics,


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  


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

0 Answers  


Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

1 Answers   CybAge,


what is the difference between tuple calculus and domain calculus ?

2 Answers   Infosys,


Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

0 Answers  


Is hive a database?

0 Answers  


Categories