Interested to Buy Any Domain ? << Click Here >> for more details...
What is better - 2nd Normal form or 3rd normal form? Why?
- 2 Answers
- 11848 Views
- TCS, TPK, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to optimize stored procedures in sql server?
How to execute function in stored procedure sql server?
how to overcome kernel isssues
What is the most common type of join?
What is collation?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Explain different types of lock modes in sql server 2000?
Difference between aggregate functions of sql?
how to do partition in sqlserver
What are the different types of subquery?
what is checksum in sql server.........???
What are the differences between char and varchar in ms sql server?
Mention the differences between having and where clause.
How to return the second 5 rows in ms sql server?
What is tempdb database? : SQL Server Architecture
