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

Is crud a cuss word?

778


how to use myisamchk to check or repair myisam tables? : Sql dba

711


what is log shipping? : Sql dba

822


What do you mean by stored procedures? How do we use it?

712


Which sql statement is used to delete data from a database?

651






What do you think about pl/sql?

701


What is error ora-01000: maximum open cursors exceeded

783


What are different joins used in sql?

727


What is the sql*loader? : aql loader

777


Why do we use function in pl sql?

753


How do you optimize a stored procedure query?

732


what are ddl statements in mysql? : Sql dba

770


Why do we use procedures?

696


what is an extent ? : Sql dba

751


What is difference between stored procedures and application procedures?

764