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.

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

How many columns can we include on clustered index ?

0 Answers  

---

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

0 Answers  

---

What are the different types of stored procedures?

0 Answers  

---

what is mean by constraints in sql?

5 Answers   Granada, IBM,

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

Define self join in sql server joins?

0 Answers  

---

What are different types of statement?

0 Answers  

---

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

Can group functions be used in the order by clause in ms sql server?

0 Answers  

---