Home > Software > Databases > PL-SQL
Interview Questions   Tutorials   Discussions   Programs   Videos   

PL-SQL - What is normalization and types of normalization?




526
views
asked mar February 12, 2015 12:56 AM  

What is normalization and types of normalization?


           

1 Answers



 
answered By   0  

Normalization is process for reducing the redency of the data.there 5 normal forms mainly used in 3 forms 4th one boyesscoded normal form First normal form (1NF) An entity type is in 1NF when it contains no repeating groups of data. Second normal form (2NF) An entity type is in 2NF when it is in 1NF and when all of its non-key attributes are fully dependent on its primary key.

Third normal form (3NF) An entity type is in 3NF when it is in 2NF and when all of its attributes are directly dependent on the primary key.

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert