Finding Additional functional dependencies in a relation
A→B
- A determines B
- A functionally determines B
- B is functionally dependent on A
- For a given value of A, we can functionally determine the value of B.
Example : AB→B, A→ ACB etc.
additional functional dependencies
Example:
Explanation:
Step-1:
Step-2:
Step-3:
Φ → Φ :
A→Φ :
A→A :
A→B :
A→AB :
B→Φ :
B→A :
B→B :
B→AB :
AB→Φ :
AB→A :
AB→B :
AB→AB :
Φ→Φ, A→Φ, A→A, A→B, A→AB, B→Φ, B→A, B→B, B→AB, AB→Φ, AB→A, AB→B, AB→AB