In focus

    About 3NF

    3NF can applies only when every non-prime attribute of table must be dependent on primary key or we can also say that there should not be the case that a non-prime attribute is determined by another non-prime attribute. So this transitive functional dependency should be removed from the table and also the table must be in Second Normal form. 3NF is fully based on the Transitive Dependency and there always 2NF requirement are be fulfillments. 3NF states that all column reference in referenced data that are not dependent on the primary key should be removed. Another way of putting this is that only foreign key columns should be used to reference another table, and no other columns from the parent table should exist in the referenced table.