adspace


Explain the concept of normalization.

Answer Posted / hr@tgksolutions.com

Normalization is the process of organizing data to minimize redundancy and improve data integrity.
Normal Forms:
• 1NF: Eliminate repeating groups, ensure atomicity.
• 2NF: Ensure 1NF and remove partial dependencies.
• 3NF: Ensure 2NF and remove transitive dependencies.
• BCNF: Ensure 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 advantages of sql ? : Sql dba

1154


what is schema? : Sql dba

1163


what are all the common sql function? : Sql dba

1141


how to escape special characters in sql statements? : Sql dba

1124


What is the current version of sql?

1106


Is primary key always clustered index?

1101


If a cursor is open, how can we find in a pl/sql block?

1252


what is sql server agent? : Sql dba

1188


What is the best sql course?

1063


what are aggregate and scalar functions? : Sql dba

1142


How do I remove duplicates in two columns?

1202


how many tables will create when we create table, what are they? : Sql dba

1155


What is your daily office routine?

2352


what is bcp? When does it used? : Sql dba

1065


Is primary key clustered index?

1027