| While developing any application software or in a | | | | 1NF) through five (Fifth Normal Form or 5NF). |
| process of dynamic web page development we must | | | | First Normal Form (1NF): Setting the rules to organize |
| use a database to store the records. Database | | | | the database |
| normalization is the process of improving the | | | | - Remove duplicate columns from individual tables |
| efficiency of a database. A normalized database is | | | | - Create separate tables for each group of related |
| the key to data-integrity in designing any | | | | data or attribute |
| database-driven application or websites development. | | | | - Assign a primary key to identify each row in a table |
| The normalization process organizes a database with | | | | Second Normal Form (2NF): Removing the duplicate |
| consistent, relevant and non-redundant records. | | | | values |
| The basic purposes of normalization: | | | | - Place sets of similar data applicable to multiple rows |
| - Remove any modification anomaly from the | | | | of a table, in separate tables. |
| database | | | | - Use foreign keys to relate these new tables |
| - Reduce the time in redesigning while extending the | | | | Third Normal Form (3NF): Field elimination |
| database | | | | - Remove fields or columns that are not dependent |
| - Support for all regular queries | | | | on the primary key. |
| A series of guidelines or rules have evolved so far on | | | | The fourth and the fifth normal forms are scarcely |
| normalizing databases which are now standard | | | | used in practice and if disregarded, the database |
| practices for developing databases in organizations | | | | functionality may not be affected. |
| providing application and website development | | | | The normalization rules are all cumulative in nature, i.e., |
| services . These rules are known as Normal Forms | | | | the Second Normal Form can be implemented only |
| (NF) and numbered from one (First Normal Form or | | | | when all criteria of the First Normal Form are met. |