Normalisation

Normalization is a method to remove all these anomalies and bring the database to a consistent state.

·               First Normal Form

First Normal Form is defined in the definition of relations (tables) itself.

·        Second Normal Form

If we follow second normal form, then every non-prime attribute should be fully functionally dependent on prime key attribute.

·               Third Normal Form

·               Boyce-Codd Normal Form

Boyce-Codd Normal Form (BCNF) is an extension of Third Normal Form on strict terms.

for detailed information download PDF

downloading servers are below

server 1 [media fire]