Database Normalization Tutorial with example

Database Normalization Tutorial with example

Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored. Database normalization is the process of organizing the fields and tables of a relational database to minimize redudancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database using the defined relationships. Normalization is a process of simplifying the relationship between the data in a record it is carried out for the following reasons. To simplifying the maintenance of data through updates, insertion and deletions To allow simple retrieval of data in response to query and requests To avoid restructuring of data when new application requirements arises. To structure the data so that any relationship can be easily represented