In order to illustrate the normalization process let us consider one simple example.

Example of normal forms in database. If playback doesnt begin shortly try restarting. Chomsky normal Form and Examples. These normal forms attempt to minimize the number of fields involved in a composite key as suggested by the examples to follow.

Unnormalized form or UNF. Forth Normal Form 4NF 6. Example 2 For example consider relation RA B C A - BC B - A and B both are super keys so above relation is in BCNF.

This is a single table database. Fifth Normal Form 5NF. Third Normal Form 3NF 4.

Normal forms are used to eliminate or reduce redundancy in database tables. What is 3rd normal form. In my previous article i have given the information about First Normal Form with real life examplesIn this article i would like to give you Second Normal Form with real life industry examplesWe need to check all the normal forms to make your database normalizedThis article gives you information about 2NF in depthThe Second Normal Form data must be in First normal form and all non-key.

There are various level of normalization. Third normal form addresses the tables that are already in second normal form. This table contains the data of three database entities.

So the highest normal form of relation will be 2nd Normal form. If all group of relations are represented as sets following figure can be drawn. In other words every 2NF is also in 1NF.