Third Normal Form (3NF)

Posted on January 26, 2010 by vivekjohari
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.

Related Aticles

Database Normalization
First Normal Form (1NF)
Second Normal Form (2NF)

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in SQL Normalization, SQL Server and tagged , . Bookmark the permalink.

46 Responses to Third Normal Form (3NF)

  1. swapna jain says:
    August 23, 2012 at 11:02 am

    sir,
    please tell about boycee codd,4th normal form ,5th normal form with example.
    Thanks

    Reply
  2. Anonymous says:
    August 30, 2012 at 4:19 pm

    Sir, Can you please give a brief idea about Object Oriented Database System?

    Reply
  3. Anonymous says:
    October 6, 2012 at 4:11 pm

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

    Reply

  4. Pingback: Kalmar instagram miss maria Nyberg

  5. Pingback: Poker Online

  6. Pingback: stump removal

  7. Pingback: useful reference

  8. Pingback: Lady Fitness - funkcionālais treniņš trenažieru zālē un grupu nodarbības

  9. Pingback: Top Realtor Tallahassee

  10. Pingback: 바카라사이트

  11. Pingback: 바카라사이트

  12. Pingback: 사설토토사이트 추천

  13. Pingback: 바카라사이트

  14. Pingback: click here to read the entire article

  15. Pingback: Torch search onion

  16. Pingback: movies

  17. Pingback: Top Movies

  18. Pingback: 11 10 2019

  19. Pingback: w88top

  20. Pingback: smotretonline2015.ru

  21. Pingback: Serial smotret

  22. Pingback: kinokrad 2020

  23. Pingback: https://meridianidhouses.com/

  24. Pingback: Website

  25. Pingback: Watch Series Online 2020

  26. Pingback: Kinokrad 2019 Kinokrad Hd

  27. Pingback: serial 1

  28. Pingback: togel online

  29. Pingback: serial

  30. Pingback: bags game

  31. Pingback: Darknet Empire Market

  32. Pingback: Drogen kaufen

  33. Pingback: Tochka Market

  34. Pingback: lostfilmtv net

  35. Pingback: Can You Buy Percocet Online Without A Prescription

  36. Pingback: trustedmdstorefy.com

  37. Pingback: bofilm

  38. Pingback: Êîíñóëüòàöèÿ ïñèõîëîãà

  39. Pingback: topedstoreusa.com

  40. Pingback: hqcialismht.com

  41. Pingback: viagramdtrustser.com

  42. Pingback: myonlinebuy.us

  43. Pingback: lindamedic.com

  44. Pingback: rick and morty season 3

  45. Pingback: 2020

  46. Pingback: koma 2020

Leave a Reply