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.
Database Normalization
First Normal Form (1NF)
Second Normal Form (2NF)
sir,
please tell about boycee codd,4th normal form ,5th normal form with example.
Thanks
Sir, Can you please give a brief idea about Object Oriented Database System?
Thanks very well explained and in a very easy manner.Can you please explain 3.5NF,4NF,5NF,6Nf,7NF too with easy examples!!!!