How many types of functional dependencies in DBMS?

Answer 1

In DBMS there is three type of functional dependency

1 FULL FUNCTION DEPENDENCY.

2 PARTIALLY FUNCTION DEPENDENCY.

3 TRACIENT FUNCTION DEPENDENCY.

Functional Dependency can be classified as follows:

• Full Functional dependency Indicates that if A and B are attributes(columns)of a table, B is fully functionally dependent on A if B is functionally dependent on A ,but not on any proper subset of A.

• Partial Functional Dependency Indicates that if Aand B are attributes of a table , B is partially dependent on A if there is some attribute that can be removed from A and yet the dependency still holds.

• Transitive Functional Dependency: A condition where A , B and C are attributes of a table such that if A is functionally dependent on B and Bis functionally dependent on C then C is Transitively dependent on A via B

For Detailed explanation with example visit Authors original Posting

http://www.mahipalreddy.com/dbdesign/dbqa.htm