• 1NF (First Normal Form) – Eliminates duplicate columns, ensure

Explain different types of Normalization.

Question Posted / hr@tgksolutions.com

1 Answers
1815 Views
HPCL, Hughes Systique Corporation, Ittiam Systems, I also Faced
E-Mail Answers

• 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

Please Help Members By Posting Answers For Below Questions

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

1094

Can sql server 2016 run on windows 7?

908

Is sql server 2016 free?

919

Which language rdl files made of?

128

What is a collation?

1084

What is b tree index?

909

How to enable/disable indexes?

1050

What is database dimension? : sql server analysis services, ssas

1069

List out what other servers you can use with ssrs?

137

What is deploy, process and build? : sql server analysis services, ssas

1094

Do you know what is a trace frag? Where do we use it?

983

What are the properties of primary key?

965

Determine how to use the inserted and deleted pseudo tables?

978

How to create median function?

164

What is the exact numeric data type in sql?

992