What is Database Normalization? Explain 3NF ?
Database normalization (NF)
1110
09-Jul-2018
Updated on 09-Jul-2018
Prakash nidhi Verma
09-Jul-2018Database Normalization is a technique of organizing the data in the database. Normalize the redundancy with Insertion, Update and Deletion Anamolies of the data into database. It is a multi- step process in which we gave data in tubler form and than removing duplicated data from the relation tables.
Third normal form(3NF) is used in database normalization as a normal form.its states in that table is in 3NF. The given relation R(table)is in 2NF. Every non-prime attribute is non-transitively dependent on every key in R.
Example :
in transitive dependency with the third normal form, all you need to do is to move the Street, City and the State fields into their own table.