- Home
- Search
- Settings
- Top Contributors
- Help Center
How many types of functional dependencies in DBMS?
Answer:
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:
For Detailed explanation with example visit Authors original Posting
http://www.mahipalreddy.com/dbdesign/dbqa.htm
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 A and 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 B is 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
Contributor:
Ganabyndoor
Ganabyndoor
First answer by ID1975833873.
Last edit by Ganabyndoor.
Contributor trust: 1
[recommend contributor
recommended].
Question popularity:
2
[recommend question].
When was the Jj.Thompson model discovered?
In: Science
Answer it!
Is oneness theology wrong?
Answer it!
» more