Functional Dependency

• Functional dependencies describe a relationship between attributes within a db table
• Denoted by, X -> Y, where X is the determinant and Y is the dependent
• Crucial concept for efficient data storage without redundancy

Types of functional dependencies §

1. Trivial - {Emp_ID, Emp_Name -> Emp_Name}
2. Non-Trivial - {Emp_ID} -> {Emp_Name}
3. Multi-valued - {Emp_ID} - {Emp_Name, Emp_Age}
4. Partial - {Emp_Name} -> {Emp_ID}
5. Transitive - {Company_ID} -> {Ceo_Age}

Refs §

1. https://www.geeksforgeeks.org/types-of-functional-dependencies-in-dbms/