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

Is sql microsoft?

706


Which nosql database is best?

675


What is having clause in sql?

713


What are some emotional triggers?

745


What are the parameter modes supported by pl/sql?

728






What are the different ddl commands in sql?

738


What does sign mean sql?

757


What are the types of functions in sql?

742


Does sap use sql?

715


What are different types of queries in sql?

731


What is sqlca in db2?

686


What is date functions?

726


What are tables and fields in the database?

746


How many developers work on postgresql?

733


What is the primary key?

698