What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6 th Normal Form. However, in most practical applications, normalization achieves its best in 3 rd Normal ...
Comments
Post a Comment