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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is better - 2nd Normal form or 3rd normal form? Why?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is better - 2nd Normal form or 3rd normal form? Why?..

Answer / pandian s

1.2nd Normal Form is the 'BEST' in real time scenario.

2.But, The 3rd Normal Form is good in theoritical ONLY not
in REAL TIME SCENARIO.

3.The 2nd Normal form tells "Eliminating Redundant of
Data" - The repeatition of data should be in seperate table
and mapped with parent table (PARENT - CHILD Relationship,
What we using in real scenario (Primary Key & Foreign Key).

4.The 3nd Normal form tells "Eliminating Data that is not
part of KEY" - The each and every columns' data should be a
part of KEY.

ie: We have Student(RollNo, StudName, Class, Phone,..)
table. Each columns' data should be referred from KEY
columns.

"RollNo" should be referred from Parent ROLL Table,
"StudName" should be referred from Parent NAME Table,
"Class" should be referred from Parent CLASS Table,
"Phone" should be referred from Parent PHONE Table

Finally, 2nd NF is BETTER than 3rd NF.

Is This Answer Correct ?    6 Yes 1 No

What is better - 2nd Normal form or 3rd normal form? Why?..

Answer / varun4db

3rd normalization is better in data warehousing.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is a non equi join?

0 Answers  

Does the order of columns in update statements matter?

0 Answers  

what's sql server? : Sql server database administration

0 Answers  

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

What is the server name for sql management studio?

0 Answers  

What are sql server procedures?

0 Answers  

What is scalar user-defined function?

0 Answers  

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

What are data files?

0 Answers  

What are the purposes of floor and sign functions?

0 Answers  

Explain about Normalization?

0 Answers   Infosys,

What is a view? is View updatable?

17 Answers   IBM, L&T,

For more SQL Server Interview Questions Click Here
Categories