The below normal forms should be enforced when the table of a database is designed.
First Normal Form:
A table is not in first normal form if it stores multiple values for a piece of information.
Action:
If a table is not in first normal form, remove the multivalued information from the table. Create a new table with that information and the primary key of the original table
Second Normal Form:
A table is in second normal form if it is in first normal form and we need all the fields in the key to determine the values of the non-key fields.
Action:
If a table is not in the second normal form, remove those non-key fields that don’t depend on the whole of the primary key. Create another table with these fields and the part of the primary key that they do depend on.
Third Normal Form:
A table is in third normal form if it is in second normal form and no non-key fields depend on a field(s) that is not the primary key.
Action:
If a table is not in third normal form, remove the non-key fields that depend on the non-key field(s). Create another table with these fields and the fields that they do depend on.
As long as the table confirms the three normal forms, it can eliminate some insertion and deletion problems.