Tell me what is normalization? Explain different forms of normalization?

Question Posted / preeti devi

1 Answers
1089 Views
I also Faced
E-Mail Answers

Tell me what is normalization? Explain different forms of normalization?..

Answer / Harshvardhan Aditya

{"Normalization": "A process in database design to organize and structure a database to minimize redundancy, improve data integrity, and enhance efficiency. It involves dividing larger tables into smaller tables and defining relationships between them using foreign keys.n"Form of Normalization": {"First Normal Form (1NF)": "Eliminate repeated groups and ensure each column contains atomic values, i.e., indivisible values that cannot be further divided.", "Second Normal Form (2NF)": "Eliminate partial dependencies by ensuring that a table only has a primary key and is fully dependent on it.", "Third Normal Form (3NF)": "Eliminate transitive dependencies, i.e., when non-key attributes depend on other non-key attributes.", "Fourth Normal Form (4NF)": "Eliminate multi-valued dependencies, i.e., when a table contains multiple related tables.", "Fifth Normal Form (5NF) and above": "Higher normal forms focus on further reducing redundancy, but they are rarely used in practice due to the complexity and minimal benefits."}

Is This Answer Correct ?

0 Yes

0 No

Post New Answer