Explain the concept of normalization.

Answers were Sorted based on User's Feedback



Explain the concept of normalization...

Answer / nashiinformaticssolutions

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

Explain the concept of normalization...

Answer / 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

Explain the concept of normalization...

Answer / 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

More SQL PLSQL Interview Questions

Explain character-manipulation functions?

1 Answers  


what is oracle database ? : Sql dba

1 Answers  


What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,


What is package in pl sql with an examples?

1 Answers  


What is the difference between a primary key and a clustered index?

1 Answers  


Is drop table faster than truncate?

1 Answers  


Explain correlated query work?

1 Answers  


Is join an inner join?

1 Answers  


What are the types of operators available in sql?

1 Answers  


What does desc stand for?

1 Answers  


What can I use instead of union in sql?

1 Answers  


Explain aggregate functions are available there in sql?

1 Answers  


Categories