Normalization Example

Example processes normalization of table:

Normalization form 1: 

A relationship accomplishes 1NF if and only if each attribute of that relationship just have singles point in a line or record.

Normalization form 2:

A relationship accomplishes 2NF if and only if:

1. 1NF's pock.
2. Each attribute which don't main key depend functionally to all key attribute and be not just play favorites attribute.

Normalization form 3:

A relationship accomplishes to form 3NF if and only if:

a.       That relationship 2NF's pock

b.      Each attribute doesn't key not pending functionally goes to attribute don't key the other in that relationship

Finally all table was normal. To download Normalization example  here in.