What is better - 2nd Normal form or 3rd normal form? Why?
- 2 Answers
- 11020 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 download and install microsoft sql server management studio express?
What is the difference between an index and a unique index?
What does truncate do?
Write an sql query to find first weekday of the month?
What are a database and a data warehouse?
What is a schema in ms sql server 2005?
Write a SQL queries on Self Join and Inner Join.
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What is the boxing and unboxing concept in .net?
What is data compression?
Explain insert into select statement?
What is the most common type of join?
What are the types of indexes?
What is DCL?
What is a fan-out query in SQL Azure?
