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.

We need to perform what steps in the following order to work with a cursor?

0 Answers  

---

How to Execute an Operating System Command From Within SQL Server ?

3 Answers  

---

What is a materialized view?

3 Answers  

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

---

What are sql server functions?

0 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

How can you stop stored procedures from recompiling?

0 Answers  

---

What are window functions in sql server?

0 Answers  

---

How to drop existing views from a database in ms sql server?

0 Answers  

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---