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 are the default system databases in sql server 2000?

0 Answers  

---

What is dirty page?

0 Answers  

---

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

---

what is a correlated sub-query? : Sql server database administration

0 Answers  

---

How do you set a trace flag in sql server?

0 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

event classes in sql server

2 Answers   Accenture, AFE,

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

What is the concept of optimization?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What does the on update no action do?

0 Answers  

---

What is data source object?

0 Answers  

---