Answer / hr@tgksolutions.com

• 1NF (First Normal Form) – Eliminates duplicate columns, ensures atomicity.
• 2NF (Second Normal Form) – Removes partial dependencies.
• 3NF (Third Normal Form) – Removes transitive dependencies.
• BCNF (Boyce-Codd Normal Form) – Ensures every determinant is a candidate key.

Answer / Diksa Kapoor

Normalization in DBMS is a process to eliminate data redundancy and improve data integrity. There are three normal forms (1NF, 2NF, 3NF) and one more advanced form (Boyce-Codd Normal Form, BCNF). Each form has specific rules that the tables must follow.

Can you get second highest salary from the table?

1 Answers   QuestPond,

---

What is the difference between clustered index and primary key?

1 Answers  

---

In what version of sql server were synonyms released?

1 Answers  

---

What is difference between rollback immediate and with no_wait during alter database?

1 Answers  

---

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

---

What are the 10 characteristics of data quality?

1 Answers  

---

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

1 Answers  

---

What are commonly used odbc functions in php?

1 Answers  

---

Explain user defined functions?

1 Answers  

---

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

---

What is the sql server 2000 version number?

1 Answers  

---

Can sql servers linked to other servers?

1 Answers  

---