Example of Full Functional Dependency; Partial Dependency; Transitive Dependency

Coloured Line

MACHINE_TYPE (Machine-no, Type-code, [pk] Weight, Colour)

Type-code   FD Arrow   Weight 

Colour   FD Arrow   Type-code 

Type-code, Machine-no   FD Arrow   Colour 


MACHINE_TYPE


Full Functional Dependencies

Weight is fully functionally dependent on {Type-code}

Type-code is fully functionally dependent on {Colour}

Colour is fully functionally dependent on {Type-code, Machine-no}


Partial Functional Dependency

Weight is partially dependent upon {Type-code, Machine-no}


Transitive Dependency

Weight is transitively dependent upon {Colour}