Through normalisation we can achieve the following benefits:
1. Minimise redundancy
2. Minimise insertion abnormalities
3. Minimise deletion abnormalities
4. Minimise update abnormalities
Consider a relation which contain employee details and departments. There are certain problems in this type of data base. If we want to insert a new department without employees it can cause difficulties. Normally employee identification number ( or social security number etc.) may be a key value. We cannot keep it null. But if we have separate employee and department tables then such a problem will not raise. New department can be inserted in the department table and new employee will be entered into employee table and they do not interfere with each other.
0 Comments