View Design Functional Dependency Er Diagram Example Download Zip Gif. Functional dependency is when one attribute determines another attribute in a dbms system. In this example, if we know the value of employee number, we can obtain employee name, city, salary dependent.
The normal forms 3nf and bcnf.
Fd sets f and g are equivalent if the imply the same set of fd s e.g. Drawing boxes or symbols of many shapes and connect them os: If t and s agree on all attributes in x then they must agree on all. In this example, if we know the value of employee number, we can obtain employee name, city, salary dependent.