When designing a database using normalization what kind of p
When designing a database using normalization, what kind of problems can you expect?
Solution
Normalization is basically to design a database schema such that duplicate and redundant data is avoided. If some piece of data is duplicated several places in the database, there is the risk that it is updated in one place but not the other, leading to data corruption.
without normalization, database systems can be inaccurate, slow, and inefficient, and they might not produce the data you expect.
The following are the three most common normal forms in the normalization process:
The first normal form
The second normal form
The third normal form
please check the link for above Normal forms
http://www.studytonight.com/dbms/database-normalization.php
