Tutorials About Us Contact Us Login / Sign up
DBMS Home / DBMS / Full functional dependency(FFD)
DBMS Full func onal dependency(FFD) Introduc on to DBMS
The term full functional dependency (FFD) is used to indicate the minimum set of attributes in of a functional Database System Architecture
dependency (FD). In other words, the set of attributes X will be fufunctionally dependent on the set of attributes
Y if the following conditions are satisfied:
Introduc on to SQL
X is functionally dependent on Y and Advanced SQL
X is not functionally dependent on any subset of Y.
In relation ASSIGN of table it is true that
PL / SQL and Triggers
FD: {EMP-ID,PROJECT, PROJECT-BUDGET} -> {YRS-SPENT-BY-EMP-ON PROJECT}
Func onal Dependency and
The values of EMP-ID, PROJECT and PROJECT-BUDGET determine a unique value of YRS-SPENT-BY-EMP-ON- Decomposi on
PROJECT. However, it is not a full functional dependency because neither the EMP-ID -> YRS-SPENT-BY-EMP- Basics of Functional Dependency
ON-PROJECT nor the PROJECT -> YRS-SPENT-BY-EMP-ON-PROJECT holds true. Functional Dependency Diagram and
In fact, it is sufficient to know only the value of a subset of {EMP-ID, PROJECT, PROJECTBUDGET), namely,
Examples
{EMP-ID, PROJECT}, to determine the YRS-SPENT-BY-EMP-ON PROJECT. Thus, the correct full functional
dependency (FFD) can be written as: Full functional dependency(FFD)
FD:
FD: {EMP-ID,PROJECT} -> {YRS-SPENT-BY-EMP-ON-PROJECT} Redundant functional dependencies
Closures of a set of functional
dependencies
Relation R1:BUDGET Decomposition
PROJECT PROJECT-BUDGET
Dependency-Preserving
P1 INR 100 CR
P2 INR 150 CR Decomposition
P3 INR 200 CR
P4 INR 100 CR Normaliza on
P5 INR 150 CR
P6 INR 300 CR Transac on Processing
Relation R2:ASSIGN
YRS-SPENT-BY-
EMP-NO PROJECT
EMP-ON-PROJECT
106519 P1 5
112233 P3 2
106519 P2 5
123243 P4 10
106519 P3 3
111222 P1 4
Online Masters UNICAF
Ad Earn an up to 60% UNICAF
Scholarship From A Recognised…
UNICAF Scholarships
Apply Now
Online Masters UNICAF
Ad Earn an up to 60% UNICAF
Scholarship From A Recognised…
UNICAF Scholarships
Apply Now
Prev Next
Subscribe us on Youtube Share This Page on
Tutorial ink
YouTube
Ask Ques on
Name Email
Write Your Question!
Post Comment
I'm not a robot
reCAPTCHA
Privacy - Terms
© Tutorialink.com - 2019
