Explain the concept of the third normal form in a database and its role in data normalization.

The Third Normal Form (3NF) is a stage of database normalization aimed at eliminating redundancy and update anomalies.

A table is in 3NF if:

1. It is already in 2NF (all non-key attributes depend on the entire key).
2. There are no transitive dependencies, meaning non-key fields do not depend on each other, only on the key.

This helps avoid situations where changing one field requires updates in multiple places, reducing the likelihood of errors and simplifying data maintenance.

Example: if a table of employees has fields EmployeeID, DepartmentID, and DepartmentName, then DepartmentName depends on DepartmentID, not directly on EmployeeID. In 3NF, DepartmentName is separated into a different departments table.