Normalization in SQL

 Normalization :-

       Normalization is a Database technique which can help us to remove redundancy. Redundancy 

       means In a colum1 Country and  column2 Sales so here we are adding the sales of Country.

                     

      In country Column i have India and Ind Both meaning are same but when i find total record of 

      India it will give me 700 Sales so this is redundancy .For removing redundancy we need to create a

      master table and where we can add Country and  link it with relationship.

      

                

   1st Normalization ,2nd Normalization, 3rd Normalization :-

      Multivalued :- same Column Can have comma separate Files or more than 1 values. 

                         eg :- fullname i want to change all singh to yadav its not possible  so here follow the                                         1nf 

                    

     1 nf :-Help us to  avoid Redundancy and Multiple value in Column For that we  need to split the

               column   and  edit the Singh to Yadav.

                     

 

     2 nf :- non key Column Can fully depend on the primary key. so that we need to Split the table 

                and link with Primary key.

                 for eg : 

                         

                split the table :-

                   

     3 nf :- Transient in Nature .  non-key column can not fully depend on another non-key column

     

              

             TotalAmount ,Cost and Unit are non-key column. TotalAmount is fully Depend on Unit and

                    Cost