adspace


Explain the concept of normalization.

Answer Posted / glibwaresoftsolutions

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 is sql server agent? : Sql dba

1188


What is the current version of sql?

1106


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

1252


What is the best sql course?

1063


what is collation? : Sql dba

1242


Is inner join faster than left join?

1287


define sql insert statement ? : Sql dba

1108


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

1124


Is primary key clustered index?

1027


What is the current version of postgresql?

1188


Does group by remove duplicates?

1120


Can we rollback truncate?

1083


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2100


how to start mysql server? : Sql dba

1279


How do I remove duplicates in two columns?

1202