- Based on concept of full functional dependency:
– A and B are attributes of a relation,
– B is fully dependent on A if B is functionally dependent on A but not on any proper subset of A.
- 2NF – A relation that is in 1NF and every non-prime attribute is fully functionally dependent on the primary key.
– Prime attribute: An attribute that is member of the primary key K
– Example: EMP_PROJ(SSN, Pnum, Hours, Ename, Pname, Ploc)
{SSN,Pnum}–>Hours, SSN–>Ename, Pnum–>{Pname, Ploc}
* Relation is not in 2NF
Advertisement
