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

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 an index. What are the types?

0 Answers  


What is implicit cursors?

0 Answers  


Can we use having clause without group by?

0 Answers  


what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,


How can a database be repaired?

0 Answers  






How to create a view with data from multiple tables?

0 Answers  


what is an index? : Sql server database administration

0 Answers  


How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,


What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,


What does set rowcount do?

0 Answers  


How does recursive cte works in sql server?

0 Answers  


What are examples of triggers?

0 Answers  


Categories