- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Fully-functional dependency in DBMS
An attribute is fully functional dependent on another attribute, if it is Functionally Dependent on that attribute and not on any of its proper subset.
For example, an attribute Q is fully functional dependent on another attribute P, if it is Functionally Dependent on P and not on any of the proper subset of P.
Let us see an example −
<ProjectCost>
ProjectID | ProjectCost |
001 | 1000 |
001 | 5000 |
<EmployeeProject>
EmpID | ProjectID | Days |
E099 | 001 | 320 |
E056 | 002 | 190 |
The above relations states that −
Days are the number of days spent on the project.
EmpID, ProjectID, ProjectCost -> Days |
However, it is not fully functional dependent.
Whereas the subset {EmpID, ProjectID} can easily determine the {Days} spent on the project by the employee.
This summarizes and gives our fully functional dependency −
{EmpID, ProjectID} -> (Days) |
- Related Articles
- Functional dependency in DBMS
- Explain about partial and fully functional dependency
- What is functional dependency in DBMS?
- What is functional dependency and transitive dependency (DBMS)?
- Partial Dependency in DBMS
- Transitive dependency in DBMS
- Multivalued dependency in DBMS
- Join dependency in DBMS
- Explain join dependency in DBMS
- What is Transitive dependency in DBMS?
- What is multivalued dependency in DBMS?
- What is Multivalued Dependency (DBMS)?
- Explain the inference rules for functional dependencies in DBMS
- Which normal form is the highest that satisfies the functional dependencies(DBMS)?
- Dependency Injection in C#

Advertisements