Further improvement of second normal form (2NF) is third normal form (3NF). We hope you are clear about 1NF and 2NF, if not do go through them:
A table is in third normal form (3NF) if it satisfies following two conditions:
Let’s say in a table, there are three columns A, B, C such that:
Then C transitively depends on A. This is called transitive dependency.
For example, we have table Department.
Suppose for each department there can be only one manager, thus non-key columns Department_name and Department_Manager_Id depends on Department_Id (Primary key). But Department_Manager_Name depends upon Department_Manager_Id which further depends upon Department_Id, thus there is transitive dependency in this table. To remove transitive dependency we need to redesign the tables as given below:
Now the table is in third normal form.
Download as PDF
Read next: BCNF, 4NF and 5NF ››
« Back to Course page
May – 2020 Edition
April – 2020 Edition
March – 2020 Edition
February – 2020 Edition
January – 2020 Edition
December – 2019 Edition
Punjab Civil Services 2020