Third Normal Form (3NF)

SQL Normalization SQL Server
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy the following conditions:-
1) It should be in the 2NF
2) It should not contain any transitive dependency which means that any non key column of the table should not be dependent on another non key column.

For example, let consider a table EmpProjDetails which contains the details about the employee and its project.

Table Name:-  EmpProjDetails
Primary Key: –  EmpId

EmpId      EmpName       EmpRegDate       Projectid        ProjectName
1                  Vivek               01/01/2006            1               Bankingexpress
2                  Neha                06/06/2007            2               BankingReport

Now, the table EmpProjDetails is in Second Normal Form (2NF), but it is not in the Third Normal Form because the non key column projectName is dependent on another non key column ProjectId. So to convert this table in the Third Normal Form, we need to decompose this table into the two tables EmpInfo and ProjInfo whose structure is given below:-

Table Name:- EmpInfo
Primary Key: – EmpId

EmpId       EmpName          EmpRegDate         Projectid
1                  Vivek                   01/01/2006               1
2                  Neha                    06/06/2007               2

Table Name:- ProjInfo
Primary Key: – ProjectId

ProjectId          ProjectName
  1                   Bankingexpress
  2                   BankingReport

Now the above tables are in the Third Normal Form since they satisfy all the conditions for the Third Normal Form.

46 thoughts on “Third Normal Form (3NF)

  1. Thanks very well explained and in a very easy manner.Can you please explain 3.5NF,4NF,5NF,6Nf,7NF too with easy examples!!!!

  2. Pingback: Poker Online
  3. Pingback: stump removal
  4. Pingback: useful reference
  5. Pingback: 바카라사이트
  6. Pingback: 바카라사이트
  7. Pingback: 바카라사이트
  8. Pingback: Torch search onion
  9. Pingback: movies
  10. Pingback: Top Movies
  11. Pingback: 11 10 2019
  12. Pingback: w88top
  13. Pingback: Serial smotret
  14. Pingback: kinokrad 2020
  15. Pingback: Website
  16. Pingback: serial 1
  17. Pingback: togel online
  18. Pingback: serial
  19. Pingback: bags game
  20. Pingback: Drogen kaufen
  21. Pingback: Tochka Market
  22. Pingback: lostfilmtv net
  23. Pingback: bofilm
  24. Pingback: topedstoreusa.com
  25. Pingback: hqcialismht.com
  26. Pingback: myonlinebuy.us
  27. Pingback: lindamedic.com
  28. Pingback: 2020
  29. Pingback: koma 2020

Leave a Reply