Normalization is the process of organizing data to minimize redundancy and remove ambiguity. Normalization involves separating a database into tables and defining relationships between the tables. There are three main stages of normalization called normal forms. Each one of those stages increases the level of normalization. The 3 main normal forms are as follows:
First Normal Form (1NF): Each field in a table must contain different information.
Second Normal Form (2NF): All attributes that are not dependent upon the primary key in a database table must be eliminated.
Third Normal Form (3NF): No duplicate information is permitted. So, for example, if two tables both require a common field, this common field information should be separated into a different table.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment