Explain different types of Normalization.
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What command would you use to create an index?
What is nolock hint in sql server 2008
What are the 7 disadvantages to a manual system?
Define synonym?
What is the Control Flow in SSIS
List the advantages of using stored procedures?
What is a heap?
Explain try...catch with sql server?
How to concatenate two character strings together?
What does dml stand for?
What is read committed?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Explain about unique identifier data type in sql server?
What is an index. What are the types?
What is the purpose of the tempdb database?