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 disadvantages of merge replication?

0 Answers  

---

How to create a view on an existing table in ms sql server?

0 Answers  

---

What is the contrast amongst drop and truncate?

0 Answers  

---

What is the synonym of join?

0 Answers  

---

what is statistics

1 Answers  

---

When do you think a developer should use sql server-based cursors?

0 Answers  

---

What is the system function to get the current user's user id?

3 Answers   TCS,

---

How to bind a view to the schema of the underlying tables?

0 Answers  

---

What is the difference between delete and truncate statements?

0 Answers  

---

Explain different isolation levels?

4 Answers  

---

Do you know the isolation level that sql server support?

0 Answers  

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  

---