What is better - 2nd Normal form or 3rd normal form? Why?
Answers were Sorted based on User's Feedback
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 |
Answer / varun4db
3rd normalization is better in data warehousing.
Is This Answer Correct ? | 1 Yes | 2 No |
List all the types of user-defined functions?
Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).
What is normalization? Explain different forms of normalization?
how you can move data or databases between servers and databases in sql server? : Sql server administration
How do I completely remove sql server instance?
Can multiple columns be used in sql group by clause in ms sql server?
What do you mean by normalisation?
Explain about Views?
Difference between writing SQL query and stored procedure ?
15 Answers Cognizant, Infosys, TCS, Veritas,
Can I run multiple instances of sql server 2000 at the same time on one computer?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What do we have to check in database testing?