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.

Answer / varun4db

3rd normalization is better in data warehousing.

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

---

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

---

How to sort query output in descending order in ms sql server?

0 Answers  

---

What are the purposes and advantages stored procedure?

0 Answers  

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

what is a stored procedure and trigger?

3 Answers  

---

What are the advantages of using third-party tools?

0 Answers  

---

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

Why de-normalization required?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

explain different types of constraints? : Sql server database administration

0 Answers  

---

Can you explain what is sql server english query?

0 Answers  

---