47
The Concept of Database Normalization
Normalization is a technique of organizing the data into multiple related tables to minimize data redundancy.
We break the above Employee table into two new different tables and name Employee table and Dept. table.
- Employee table will contain employees information.
- When we insert a new employee, We do not eliminate the data redundancy. However, we minimize it by only adding which department the employee works.
- When we delete employees data, it will not affect the department dataset.
- When we have a new department head, we just need to update department table. It will not affect the employee table.
- 1st Normal Form.
- 2nd Normal Form.
- 3rd Normal Form.
47